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?
|