UNIQ EXPEREINCE: PROCEDURE WORKS FINE USING F8 BUT GET ERROR WHEN COMMAND BUTTON IS CLICKED

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

CAPTGNVR

DEAR ALL

I wrote a lengthy program and each step was checked using function-8.
but when command button was used get the following error at location
ActiveSheet.Paste Link:=True
ERROR 1004 paste method of worksheet class failed

I used on error resume but the results are disastrous as too many
cells are left uncopied or formulas not written.
Can anyone guide me?? what could be the reason.??
 
Standard response is to try setting the "takefocus on click" property of the
button to False.

If that doesn't work then post some code.

Tim
 
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

Using Command Button to Hide Columns in another worksheet 2
Code created in a Macro not working for a Command Button 15
macro code doesnt work in command button 4
getting Runtime Error 1004 8
Run-time error on command button 4
Error 1004 'Range' when using French Regional options but not Engl 5
On click procedure fails, but not during debug 1
Error Message When running code but not stepping through it. 4

Back
Top