Range("CI6").Resize(Range("CI2"),1).Copy Destination:=Range("G6")

--
Regards,
Tom Ogilvy

"Greg" wrote in message
oups.com...
Hi out there,

Can someone help me with the syntax to refer to a dynamic range via
code?

I am trying to use activesheet with the following parameters:

- Start copy at cell CI6 (including CI6)
- Go down rows via value in cell CI2
- Past values to cell G6


TIA,

Greg