Hi Lens

Using some VBA code the last used cell in Row5 is:

LastCol = Cells(5,Columns.Count).End(xlToLeft).Column
Cells(5,LastCol).Select

The above two lines will put your cursor in the last column in row 5 that has data in it.
It is the same as going to a cell beyond your data (to the right) in row 5 and pressing Ctrl+Left Arrow.

Read this link for more:
http://spreadsheetpage.com/index.php...e_size_ranges/