rhoknee
07-29-2010, 06:34 PM
Hello,
I have reached my wits end. Hoping some one here will come to my rescue.
I have a working macro coded in VBA. With less data all is good. Trouble starts when I increase the ammount of the data. In this case 88 segments. I get a "Run-time Error 1004, Delete method class failed".
What is this??
At first I thought It was because my PC didn't have enough resources, but then I had a custom built "BEAST" (Corei7,12GB RAM,256 SSD), and still got the same message.
Is there any way my code can be tweaked to overcome this?
Any Input will be highly appreciated.
http://wikisend.com/download/457294/PERFECT1.xlsm
Ps In the attachment, I have 88 segments. If you try to run all, it will take for ever. It is advisable to first test with about 20 or less....
I have reached my wits end. Hoping some one here will come to my rescue.
I have a working macro coded in VBA. With less data all is good. Trouble starts when I increase the ammount of the data. In this case 88 segments. I get a "Run-time Error 1004, Delete method class failed".
What is this??
At first I thought It was because my PC didn't have enough resources, but then I had a custom built "BEAST" (Corei7,12GB RAM,256 SSD), and still got the same message.
Is there any way my code can be tweaked to overcome this?
Any Input will be highly appreciated.
http://wikisend.com/download/457294/PERFECT1.xlsm
Ps In the attachment, I have 88 segments. If you try to run all, it will take for ever. It is advisable to first test with about 20 or less....