Thread: select all non-blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
johncaleb johncaleb is offline
external usenet poster
  
Posts: 13
Default select all non-blank cells
I need a macro to select and copy all non-blank cells in Sheet1, then paste
these cells into sheet2 at Cell A1.

thanks much!
Reply With QuoteReply With Quote