There can be problems with the method I provided in terms of interpretation.
This shows the lower right corner of the area, Excel considers to be in use.
That doesn't always represent the last row that has data - it may overstate
the row, but never understate it.

There are other factors which would cause excel to overstate the usedrange
besides having data in a cell, such as cell formatting and so forth.

Ron's method will show you that last cell that actually contains data.


--
Regards,
Tom Ogilvy


"Al Lind" wrote in message
...
Works great! Thanks Tom.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!