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

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

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

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


"CAPTGNVR" wrote in message
oups.com...
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.??