Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Weird error messages
Hi all,
I'm trying to run a macro that copies some data from one worksheet to 50 other worksheets using some specific criterias. While the macro copies everything correctly for around half of the data it stops after that and gives me the following error messages: "Excel cannot complete this task with available resources. Choose less data or close other applications" In the VBE it gives me: "Run-time error 1004: Paste method of worksheet class has failed". Then when I close Excel after these messages: "The picture is too large and will be truncated". Has anyone experienced something like that before? I don't have any other applications open and I don't think that this simple procedure should cause any problems with Excel. It's really strange. Any help is greatly appreciated!!!! Manuel |
#2
|
|||
|
|||
hi,
since i don't know how much or what your are trying to paste i can only be general. I have found that when useing the copy and paste commands in a macro, if you do this a lot in one macro, excel will freeze up. the cut and paste commands are even worst. i don't know what causes it (it's a clipboard thing i think) but over the years i have just avoided the situation and learned to use other ways. post back with more info about what you are trying to paste. -----Original Message----- Hi all, I'm trying to run a macro that copies some data from one worksheet to 50 other worksheets using some specific criterias. While the macro copies everything correctly for around half of the data it stops after that and gives me the following error messages: "Excel cannot complete this task with available resources. Choose less data or close other applications" In the VBE it gives me: "Run-time error 1004: Paste method of worksheet class has failed". Then when I close Excel after these messages: "The picture is too large and will be truncated". Has anyone experienced something like that before? I don't have any other applications open and I don't think that this simple procedure should cause any problems with Excel. It's really strange. Any help is greatly appreciated!!!! Manuel . |
#3
|
|||
|
|||
Manuel,
Maybe... http://support.microsoft.com/?kbid=210684 XL2000: Copying Worksheet Programmatically Causes Run-Time Error 1004 Regards, Jim Cone San Francisco, USA "Manuel" wrote in message ... Hi all, I'm trying to run a macro that copies some data from one worksheet to 50 other worksheets using some specific criterias. While the macro copies everything correctly for around half of the data it stops after that and gives me the following error messages: "Excel cannot complete this task with available resources. Choose less data or close other applications" In the VBE it gives me: "Run-time error 1004: Paste method of worksheet class has failed". Then when I close Excel after these messages: "The picture is too large and will be truncated". Has anyone experienced something like that before? I don't have any other applications open and I don't think that this simple procedure should cause any problems with Excel. It's really strange. Any help is greatly appreciated!!!! Manuel |
#4
|
|||
|
|||
Hi there,
First of all thanks for your reply. I basically want to copy a set of dates (about 150 days) into 50 different worksheets. In each of the 50 worksheets I want to paste it 400 times. Would that be too much data? Thanks a lot, Manuel -----Original Message----- hi, since i don't know how much or what your are trying to paste i can only be general. I have found that when useing the copy and paste commands in a macro, if you do this a lot in one macro, excel will freeze up. the cut and paste commands are even worst. i don't know what causes it (it's a clipboard thing i think) but over the years i have just avoided the situation and learned to use other ways. post back with more info about what you are trying to paste. -----Original Message----- Hi all, I'm trying to run a macro that copies some data from one worksheet to 50 other worksheets using some specific criterias. While the macro copies everything correctly for around half of the data it stops after that and gives me the following error messages: "Excel cannot complete this task with available resources. Choose less data or close other applications" In the VBE it gives me: "Run-time error 1004: Paste method of worksheet class has failed". Then when I close Excel after these messages: "The picture is too large and will be truncated". Has anyone experienced something like that before? I don't have any other applications open and I don't think that this simple procedure should cause any problems with Excel. It's really strange. Any help is greatly appreciated!!!! Manuel . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula weird result | Excel Discussion (Misc queries) | |||
formulas are reading weird | Excel Worksheet Functions | |||
Weird Printing problems with spreadsheet | Setting up and Configuration of Excel | |||
Weird wrapping in cell | Excel Worksheet Functions |