Error when calling two similar subroutines at the same time

Hi,

I have two subroutines that i have written which are extremely similar and are tasked with creating charts of two different types. When called individually they work fine. However when i try and call both under one command button i get the error "method 'columns' of object '_global' failed".

The code seems to stop at the point in the second sub when it is asked to define the size of the second chart. I think this is telling me that VBA is getting confused with both codes essentially trying to define two different chart sizes for what it assumes is one set of chart objects.

Here is the code below for the two subs:

Please Login or Register  to view this content.

I'm then trying to call these two subs with one command button using this code:

Please Login or Register  to view this content.

I think lack of experience is the real error here so any help would be very much appreciated!

That's exactly where the code stops, or more specifically on the second line where columns are used to define the Left value.

I am trying to create both types of chart on one sheet which is just a normal spreadsheet. The activesheet is referring to the sheet where the code gets the chart source data from (the activesheet is created from a template and has a name which is created by the user).

I'm now thinking that if the second sub needs to be called directly after the first then somewhere in the code i need to declare that i would like it to go back to the activesheet rather than run from the sheet the charts are being created on?? I can't upload anything at the moment because the servers at the office don't let us!

I took another look at this last night and managed to solve it! As suspected, the code was getting confused with what sheet to pull the data from and also thought there were two separate commands the size of the chart. So i found a macro that i put into the sheet that selects the previously selected sheet. With the way the rest of the code runs it seems to work:

This goes into thisworkbook:

Please Login or Register  to view this content.

and this goes into a module:

Please Login or Register  to view this content.

I then called this sub within the first sub and it seems to sort things out!