Thread: macro to find the last blank cell in col. A
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default macro to find the last blank cell in col. A
This may in fact be what the OP wants, but it doesn't find the *last*
blank cell...

In article ,
Jim Thomlinson wrote:

cells(rows.count, "A").end(xlup).Offset(1,0).Select
Reply With QuoteReply With Quote