Hi all,
I need to copy a selection into a column but the cell where i need to do it can change.
I managed to indicate the correct destination in a cell named "loc" but I don't know how to tell my macro to use this value.
Here is the code I m trying to work with:
Dim loc As Range
loc = Worksheets("Resultat").Range("LOC")
Range("D2:E5").Select
Selection.Copy
Application.Goto Reference:=loc
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Thanks for any clue you can give me
Bookmarks