I need to copy a range of cells from a worksheet before the active worksheet. I can't use the name of the worksheet or its index number because these two things are always changing. So I need to reference the worksheet I want to copy from using only the active worksheet. My code looks like this:
Sub Macro6()
Sheets("1").Select
Range("C11:E11").Copy
Sheets("2").Select
Range("C11:E11").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
So sheet "2" is my active and sheet "1" is the one I need the cells from. But I need to reference sheet 1 using the active sheet ("2")
Bookmarks