Simple copy and paste macro

Hi Guys,

I have found a macro I have been using on my worksheet for a while now,

I basically copy a value from a fixed location (cell A1) to another cell which has a fixed column ("C") but a variable row.

The row number is stored in cell A2

So if cell A2 contained the value 23, I want to copy the contents of A1 to cell C23.


I have been using this code

PHP Code: 

Range("A1").Copy Destination:=Range("C" & Range("A2").Value) 


I would now like to paste the copyied cell to another sheet rather than in column "C"

However I still want the range to be dictated by "A2"


Can this be done?

Thanks for your help
Hernan

Alas! no

I get this error?

111111.JPG

"Run-time error "1004"

copy method of range class failed"

When I click Debug it highlights the whole line

Which sheet is the cell A2 that you are referencing on and what is the name of the sheet you are copying from?