It will give the next row after the last row Excel considers to be used.
Considering a row to be used doesn't necessarily have anything to do with a
particular cell being empty or not although in many situations it will give
the desired result - quite unreliable for sheets with columns of varying
lengths and so forth.
--
Regards,
Tom Ogilvy
"pikus " wrote in message
...
lrow = ActiveSheet.UsedRange.Row + _
ActiveSheet.UsedRange.Rows.Count
Will give the first empty row. Replace the word "Row" with "Column"
and get the first empty column. Is that good? - Pikus
---
Message posted from http://www.ExcelForum.com/