Using a VAR with a Goto

**stephaneg** · 02-12-2010, 05:23 AM

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:

Please Login or Register  to view this content.

Thanks for any clue you can give me

**DonkeyOte** · 02-12-2010, 05:32 AM

Welcome to the Board.

Please use CODE tags around VBA at all times... on this occasion (first post) I've modified for you.

It's not clear immediately what you want to do but you could perhaps replace your code with:

Please Login or Register  to view this content.

However your use of GoTo implies you want to navigate to your named range - is that the case ?

**stephaneg** · 02-12-2010, 06:00 AM

Thanks DonkeyOte for your quick reply, let me try to explain better what i m trying to do...

Dim loc As Range

' I m trying to give to the var loc the cell reference present in J1
loc = Worksheets("Resultat").Range("J1").Value

' Selection of the range I want to copy
Range("D2:E5").Select
Selection.Copy

' Here I want the cursor to go to the cell reference present in J1(loc)
Application.Goto Reference:=loc

' And paste the selection

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

**DonkeyOte** · 02-12-2010, 06:52 AM

As mentioned in my prior post...

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
Your post does not comply with Rule 3 of our Forum RULES.
Highlight your code and click the # at the top of your post window (click GoAdvanced if you can not see the # icon)

For more information about these and other tags, found here