ExcelBanter - Last used cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Last used cell (https://www.excelbanter.com/excel-programming/293695-re-last-used-cell.html)

Rob van Gelder[_4_]

Last used cell

I have an example on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Hawk" wrote in message
...
How do I find the last non-empty cell on a worksheet?

mudraker[_170_]

Last used cell

GetBottomRow = TheSheet.Cells.Find(what:="*", SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious).Ro

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 02:15 AM.