All the posted examples assume that column a will have an entry in th
last row used
This will give you the last row used without being depending on testin
any particular column
Rows(Cells.Find(what:="*", SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Row + 1).Selec
--
Message posted from
http://www.ExcelForum.com