Steve

Sub CopyAndPaste()
Range("A" & Range("C2").Value + 1 & ":A" _
& Range("C1").Value).Copy Destination:=Range("W1")
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Steve" wrote in message
oups.com...
I'm trying to create code to copy and paste a variable range. It's all
in column A, but the start cell is determined by the value of cell C2,
and the end by the value of C1.

EG: C1=200, C2=100, so I want the range created in the code below to
reflect that, ie A101:A200.

I've go the following:

Range("A" & (C2 + 1) & ":A" & (C1)).Select

This doesn't work. Please could anyone advise me how to:

1) correct the code above; and
2) then copy the resultant range and paste it to begin at cell W1.
Thanks in advance

Steve