G
Guest
When running macro of workbook with 200 worksheets the process gets about 75%
through with the operation and the following error is produced.
'Excel cannot complete this task with available resources. Choose less data
or close other applications.' When you click on OK the following VB error
comes up. "Run-time error '1004'; Paste method of worksheet class failed" I
have checked the memory and that does not seem to be the issue. I have no
other applications running at the time. Any thoughts would be greatly
appreciated.
Terry
through with the operation and the following error is produced.
'Excel cannot complete this task with available resources. Choose less data
or close other applications.' When you click on OK the following VB error
comes up. "Run-time error '1004'; Paste method of worksheet class failed" I
have checked the memory and that does not seem to be the issue. I have no
other applications running at the time. Any thoughts would be greatly
appreciated.
Terry