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
|