VBA code to put the active cell as first clear row.

[danjames11]

I want to be able to press a button, and for the active cell to go to the first clear row in column A. The VBA code is what i want,

Thanks, Dan.

 

[VoG]

Try

Application.Goto reference:=Range("A1").End(xlDown).Offset(1)

 

[danjames11]

Great, It worked. Thanks again VoG!


Thanks, Dan

 

[VoG]

Give us a picture of your sheet http://www.excel-jeanie-html.de/index.php?f=1