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
 
Back
Top