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!
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!