View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matto Matto is offline
external usenet poster
 
Posts: 5
Default 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