VBA Cannot Complete Task With Available Resources

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

With some help along the way from this forum here http://www.excelforum.com/excel-prog...mic-chart.html I've put together the following script which performs the following:

• Searches column B (containing approx 31,000 rows of data) of the sheet "All Data" for unique values.

• For each unique value, the code will then try to find a matching sheet with the same value within my workbook.

• Where a match is found I'm then trying to use the code below to create a graph from data on that sheet.

Please Login or Register  to view this content.

As you will see from the link I included at the beginning of this post, the script which creates the chart works perfectly when adding to a single sheet, but now that I have adapted this to add multiple charts to multiple sheets I'm now receiving the following error: "Excel cannot complete this task with available resources. Choose less data or close other applications"

Now I did make a post here: http://stackoverflow.com/questions/2...able-resources where I was fortunate to receive some replies, but despite their kindness I've been unable to resolve the problem and the internet searching I've carried out today on the error has also not been able to resolve the issue.

I just wondered whether someone may be able to look at this please and offer some guidance on where I've clearly gone wrong.

Many thanks and kind regards

Chris

[hobbiton73]

Hi All, thank you for taking the time to view my post.

After working on this for the laste few days I've managed to get this to work with the following:

Please Login or Register  to view this content.

Many thanks and kind regards

Chris