Excel : How can I find the row of a cell by finding its value

[Hind]

Hello,

I have develloped a VI which finds a value in an excel workbook, and I need a way to collect the row of the cell containing this value. 
Thank you for your help

[ben64]

---

@Hind wrote:

Hello,

I have develloped a VI which finds a value in an excel workbook, and I need a way to collect the row of the cell containing this value. 
Thank you for your help

---

That might depend on how your code is written (ActiveX? RGT?), you should attach your vi.

Ben64

[altenbach]

How do you find the value?

[Hind]

I use the activeX find

[ben64 · Accepted solution]

---

@Hind wrote:
I use the activeX find

---

Then use the Row property on the range object returned by theFind method.

Ben64

[Hind]

I have already tried it and it always returns row = 1. I have attached the VI  and thank you for your response.

[Hind]

My mistake I was using the range object returned by the replace method! 
Thank you once again !