-----Original Message-----
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
.
Hi Mike

Use the ActiveCell.Address as:
Sub ActiveCellAddress()
Dim myCellAddress As String
myCellAddress = ActiveCell.Address
MsgBox "Active cell address: " & myCellAddress
End Sub