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