ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy and Paste Cell (https://www.excelbanter.com/excel-programming/345221-copy-paste-cell.html)

Matto

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