Get row number by value

[rpaccount]

Hi,

Anyone knows how to get Row Number properly?
I received this error.
Detail: Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

I changed Start Row to 2 already. It's no longer 0.
Total Row here refers to total number of rows in the collection.
Cause i wanna delete the row of values directly in the excel sheet. instead of the collection.

So how do i get row number using the excel vbo.

Thanks!

 

[Sukesh Kumaru]

Show me your workbook if there is no sensitive data.

 

[Sukesh Kumaru]

In my Blue Prism MS Excel vbo there is no action called "Find Row Number by Value",
where did you get that.....
if it is not possible then go for using code stage.

 

[rpaccount]

Hi,

Umm. It's probably a newer version one.
Just asking if there is any way to get row number based on value given.

Thanks!

 

[Sukesh Kumaru]

You had a newer version of MS Excel vbo right,
then what is the output of that action...?