macro recording
Can also find the last used cell in column A with the following. You can
edit column A to any column you wish to find the last used cell in that
column.
Cells(Rows.Count, "A").End(xlUp).Select
The following finds the last used cell in a row. Edit the row number for any
particular row.
Cells(1, Columns.Count).End(xlToLeft).Select
--
Regards,
OssieMac
|