To answer your direct question, Selection.Row should give you that, as in
this example...

Range("Amount_Local").End(xlDown).Select
MsgBox Selection.Row

HOWEVER, you almost never have to select a cell in order to work with it in
VB. You can get the row directly like this...

MsgBox Range("Amount_Local").End(xlDown).Row

If you have more than one thing to do to the cell, use a With/EndWith
block...

With Range("Amount_Local").End(xlDown)
.Value = "New Text In The Cell"
.Font.Size = 18
.Font.ColorIndex = 3
End With

--
Rick (MVP - Excel)


"Harold Good" wrote in message
...
Hi,

I have a named range "Amount_Local" in a single column.

The following line of code will find the last cell before a blank cell,
which is what I want.
Range("Amount_Local").End(xlDown).Select

How can I get it to tell me what row it is?

thanks,
Harold