View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default select ranges of cells relative to location and then paste

ActiveCell.Offset(1,0).Range( _
"A1:A11,A15:A44,A47:A53").Value = ActiveCell.Value

Note that this has nothing to do with column A. This represents positions
relative to the activecell, so it is applicable anywhere on the spreadsheet
where you have enough rows below the activecell.

--
Regards,
Tom Ogilvy

"Buffyslay" wrote in message
om...
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 thank