row (active) into a variable

[me-gjb]

I am using the find command to locate a record. Once the record is located, what is the syntax to put the row number into a variable?

 

[Norie]

It depends how you are doing the find.

To get the row of the active cell try this.

FindRow = ActiveCell.Row

 

[HalfAce]

Yes, I had the same question.
Are you using the Find command manually, or are you using it in some code?
(If not manually can you post the code?)

 

[me-gjb]

It works, thank you.