Pasting Data

[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

 

[Ron de Bruin]

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

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

 

[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]>

wrote in message [email protected]...

 

[Don Guillett]

Sub PASTEIT()
ActiveCell = [B1]
End Sub

 

[Tom Ogilvy]

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