Thread: Select next empty row from macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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?
Reply With QuoteReply With Quote