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

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.??
 
T

Tim

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
 

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

Code created in a Macro not working for a Command Button 15
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Using Command Button to Hide Columns in another worksheet 2
macro code doesnt work in command button 4
Run-time error on command button 4
Excel macro error when workbook is shared 0
Form Button vs Command Button 2
Error 1004 'Range' when using French Regional options but not Engl 5

Top