VBA and pasting

P

Pinny

I have a spreadsheet in Excel (Office 2003). On one sheet is a command
button from the VB toolbox with some code associated with it (I can get more
specific if need be). From what I've gathered from the discussion group, it
seems that it wipes out the ability to paste in the worksheet. I can copy
and paste to another worksheet but cannot paste in this one. Is there an
explanation for this and more important perhaps, is there a work around? I'm
guessing it's something programmatic. Thanks.
 
S

Shane Devenshire

Hi,

I'm not sure what the problem your having but

Private Sub CommandButton1_Click()
Range("A1").Copy Range("C1")
End Sub

Works for me.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Top