VBA and pasting

  • Thread starter Thread starter Pinny
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste and remove blanks VBA 0
How to use OFFSET in VBA 1
VBA Code for Pasting Sheets 2
Change paste to only paste values 1
Preventing pasting except for Paste Values 8
VBA Code for Pasting Contents 3
copy and paste data only to a new file 1
How to bypass password when pasting FROM a protected workbook 3

Back
Top