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