VBA for Selecting the next empty cell in column A???

[Daniellel]

Hi,

Is there VBA code to select the next empty cell in column A???

I am currently doing this but it is only taking me to the last completed cell...

Selection.End(xlDown).Select

Thank you in advance for any help

Danielle

 

[njimack]

Selection.End(xlDown).Offset(1).Select

Note that you rarely need to select cells to perform actions on them in VBA

 

[VoG]

Try

Selection.End(xlDown).Offset(1)Select