ExcelBanter - Select next empty row from macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select next empty row from macro (https://www.excelbanter.com/excel-programming/386234-re-select-next-empty-row-macro.html)

rick_mc

Select next empty row from macro

Thanks, that did the trick

Rick

"Tom Ogilvy" wrote:

Let's say if the cell is empty in column A, the row is empty

cells(rows.count,1).End(xlup)(2).EntireRow.Select

--
Regards,
Tom Ogilvy

"rick_mc" wrote:

I have the following in my macro:
Rows("27:27").Select

I need to change this statement so that it selects the next empty row in the
report. Can someone post the code for this?

All times are GMT +1. The time now is 02:12 PM.