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:
I'm then trying to call these two subs with one command button using this code:
I think lack of experience is the real error here so any help would be very much appreciated!