Select next empty row

Joseph McGowan · Apr 8th, 2002, 01:07 PM

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 · Apr 8th, 2002, 01:15 PM

Try the following:

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

Its not great, but it works.

Apr 8th, 2002, 01:15 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: Set BlankCells = Columns("A").SpecialCells(xlCellTypeBlanks) BlankCells(1).Select Its not great, but it works. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 01:07 PM	#1
Joseph McGowan New Member Join Date: Mar 2002 Posts: 11	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.