View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buffyslay Buffyslay is offline
external usenet poster
 
Posts: 40
Default select ranges of cells relative to location and then paste

hi again

i have an active cell i have selected. *using activeCell

what i now want to do is copy whats in that cell into the
next 11 cells down
miss 3
copy into next 30
miss 2
copy into next 7

its a pain in the you know where..

any help gratefully received...

many thanks