Pasting Data

  • Thread starter Todd Huttenstine
  • Start date
T

Todd Huttenstine

Is there an easier way to write the below code?

Worksheets(1).Range("C3").Select
ActiveSheet.Paste

I tried to do this and it failed.
Worksheets(1).Range("C3").Paste

Thanx

todd huttenstine
 
R

Ron de Bruin

You don't have to select
Try this that copy the active cell

ActiveCell.Copy Worksheets(1).Range("C3")
 
T

Todd Huttenstine

I meant I wanted to paste whats already copied in the cell
C3.


-----Original Message-----
You don't have to select
Try this that copy the active cell

ActiveCell.Copy Worksheets(1).Range("C3")


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Todd Huttenstine" <[email protected]>
Click to expand...
wrote in message [email protected]...
 
T

Tom Ogilvy

Sub TestPaste()
Worksheets(1).Paste Destination:=Worksheets(1).Range("C3")
End Sub
 
Top