Tom,

Thanks! Forgot that Excel remembers the last cell even if all entries have
been cleared.

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
Many times gives inaccurate results for me.

--
Regards,
Tom Ogilvy


"STEVE BELL" wrote in message
news:Ckipe.12887$yS2.5191@trnddc07...
Dim LastRow as Long

LastRow = Cells.SpecialCells(xlLastCell).Row

--
steveB

Remove "AYN" from email to respond
"Stefi" wrote in message
...
Hi all,
I found several tips for finding the last row containing data in a
specific
column. But what can I do for finding the last row containing not empty
cells in any of the columns?
Stefi