Thread: Empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anamarie30 anamarie30 is offline
external usenet poster
 
Posts: 26
Default Empty cells

I got a spreadsheet that in sheet1 have a list of names in a range (for
example, A31:A1000) and some of the cells are in blanks. I need to copy the
list of names to sheet2 without the empty cells. How can I do that?