Hi Mike

You can read the row number directly:

ActiveCell.Row

(Likewise for .Column and .Address)
--
HTH. Best wishes Harald
Followup to newsgroup only please

"bmwmcrider" skrev i melding
om...
Hi,

I am not an Excel VBA expert and have run into a roadblock in attempts
to create a VBA script to manipulate data in S/S cells. What I want
to do is retrieve the address of the active cell. From that I want to
get the row number so that I can go to other cell in that row to read
and modify cell values.

Reviewing all the Excel classes and help files I couldn't seem to
locate a method that returns an object that contains the currently
active cell address.

Any help would be appreciated. TIA ...

Mike