I used Ron DeBruin's google search addin
http://tinyurl.com/4d2yg

--
Don Guillett
SalesAid Software

"Kaval" wrote in message
...
I want to define the last used row on a worksheet. I could use
"SpecialCells(xlLastCell)" however this also includes extra rows that were
used previously but are now empty.

I think there is a function that gives the last cell or row in a
block/table
of cells but I can't find it.

Any ideas?

Kaval