View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jared Jared is offline
external usenet poster
 
Posts: 109
Default how to copy cells which gaps exist between?

I need to copy cells with gaps between:
for example: a1 a3 a5 a7 and paste them with the gaps meaning that when i
paste them there will still be 1 cell apart, but i do not want to copy the
blank cells which exist in between.

thanks jared