Select next empty row from macro
 

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?

Select next empty row from macro
 

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?

Select next empty row from macro
 

Hi Rick

If you must check more columns see
http://www.rondebruin.nl/last.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rick_mc" wrote in message ...
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?