ExcelBanter - Active cell

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

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

- - Active cell (https://www.excelbanter.com/excel-programming/301327-active-cell.html)

Patrick Simonds

Active cell

How can I get the last cell (with data in it) in column A to be the active
cell

Tom Ogilvy

Active cell

set rng = Cells(rows.count,1).End(xlup)
rng.Activate

--
Regards,
Tom Ogilvy

"Patrick Simonds" wrote in message
...
How can I get the last cell (with data in it) in column A to be the
active
cell

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