Simple Copy value question

[AAAAndy]

I simply want to assign the value in one range to another range.
Let’s say I have Worksheet1, which has a cell named Range1 containing the value “AAA”.
I have another sheet, Worksheet2, with a cell named Range2.
I want to assign the value in Range1 to cell Range2.
Shouldn’t I be able to say…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Sub CopyLabel()
Range1 = Range2
End Sub
<o></o>
If that doesn’t work, then shouldn’t this?...
Sub CopyLabel()
Worksheets("Worksheet1").Range("Range1").Copy
Worksheets("Worksheet2").Select
Range("Range2").Select
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

Thanks!

 

[VoG]

Try

Sub CopyLabel()
Range("Range1").Value = Range("Range2").Value
End Sub

 

[AAAAndy]

Great! Thanks!