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 from different workbook

hi again,

I need a macro to select and copy all non-blank cells from Sheet1 FROM one
workbook, then paste these cells into a different workbook, sheet2 at Cell A1.

thanks much!