Macro to select cell after last row in column

[robertguy]

Hi,

Can any tell me the macro code to select the cell after the bottom of a column of data e.g. I have data in A1:A300 and I require the macro to automatically calculate the last row in the range (in this case A300) and then to select A301 (in this case)

(I know I can record a macro but the number of rows can potentially differ every time I run the macro)

Many thanks in advance

Regards Rob

N.B. Excel version 2003

[DonkeyOte]

Work from the bottom up...

Cells(Rows.Count,"A").End(xlUp).Offset(1)

(add .Row if you want/need the row number...)

[jasocke2]

Hi.

This is one possible way of selecting the next available cell in column A:

Sub Selectnextcell()
Cells(Cells(Rows.Count, "A").End(xlUp).Row + 1, "A").Select
End Sub

[robertguy]

DonkeyOte & jasocke2,


many thanks for your prompt replies they both worked as requested.


Thanks again


Rob