Select next empty row

[Joseph McGowan]

Would anyone be kind enough to tell me what code I would need to use to simply have cell (Column A Row next empty row ) selected and ready for user input.

I have 10 rows of heading at the top then add new data each day after the previous entry.Would like to be able to click macro button that would take me to this cell.

Thanks in advance.
Joe.

 

[Al Chara]

Try the following:

Set BlankCells = Columns("A").SpecialCells(xlCellTypeBlanks)
BlankCells(1).Select

Its not great, but it works.