msgbox Range("Amount_Local").End(xlDown).row
--
HTH...

Jim Thomlinson


"Harold Good" wrote:

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