Paste a value in a specified location

**Starjozzan** · 12-06-2012, 07:48 AM

In cell A2 I have a cell reference, which indicates where in the excel sheet a copied value should be pasted (The value in A2 is changeable depending on the number of lines used). I have built a macro that copies a range of values in column M and that shall be pasted in the location specified in A2, in this case Y532. But apparently it's not enough to do as I have done below. What am I doing wrong?

Range("M9").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("A2").Value.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Hopefully someone can help me.

**JosephP** · 12-06-2012, 08:06 AM

instead of

Range("A2").Value.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

use

Range(Range("A2").Value).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

**Starjozzan** · 12-06-2012, 09:54 AM

It works! I'm so grateful! Thanks.

**JosephP** · 12-06-2012, 10:03 AM

you're welcome :-)

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save