Hi,
I'm almost too embarrassed to ask this one.. but I can't work it out.
I have
This works fine if data is in A1:A6 and H1:H6 on the 'Basic Info' worksheet.. however my VBA generates a 'Basic Info' sheets with sometimes more, or less rows. So this range needs to be adaptive.
I know how to make a single range variable using a row count, but here the chart references two ranges separated by a comma (first range for X, second range for Y).
That's what's tripping me up.
I can't get the syntax right.. as I don't know how to deal with the Parentheses and the discrete worksheet reference..
I tried substituting
for
but the VBA is incorrect, i know this, the second set of Parentheses kill it. I don't know how the second range should be correctly referenced
This is really bugging me, and I've looked far and wide but not found anything that helps me with these two ranges in a single argument.
I'm a VBA hack with clearly no formal training, and I make do using examples and modifying them. It shows here!
Thanks for any help.
Bookmarks