Hi Anne,

Tom's response warrants careful consideration; it effectively represents a
mini-tutorial. Certainly, a proper assimilation would enable you to respond
to your own post and more.

Tom already shows you how to define the lastCell range. To return the
corresponding row number only requires the appendage of .Row.

Thus, for column A:

lastRow = Cells(Rows.Count, "A").End(xlUp).Row


---
Regards,
Norman



"Anne Nasser" wrote in message
...

Tom,

Thanks for those. For the first one though regarding stopping at the
last row, if you don`t know the number of the last line, for example,
2000 - what variable could be put to represent this?

Anne


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