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 |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com