Copy and Paste Cell
I get an error on this code when it trys to select the new cell reference,
can someone help me refer to the cell correctly? Thanks.
Private Sub CommandButton1_Click()
Dim rw As Long
rw = Range("T5").Value
Sheets("Adj. Savings").Select
Worksheets("Adj. Savings").Range("B1").Copy
Worksheets("Savings History").Range("B" & rw).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
|