Need VBA to edit Chart Series using active worksheet?

[davidrias]

Hello,

I have a template worksheet that I use to create other worksheets by copying and pasting sections of the template on to new worksheets. The template contains two charts. The charts that are copied onto the new worksheet are still referencing the template to get its series ranges from but I need them to be referencing the new worksheet.

Since the name of the new worksheet is everchanging, how do I reference it in the series values? I was thinking I can use the macro to edit like this...

Please Login or Register  to view this content.

And this will edit the charts data to look like this:

Capture.PNG

But I don't know the worksheet name (eg. Sheet2 could be a large number of things) so I am not sure what to put in my code that will insert the active worksheets name here...

Please Login or Register  to view this content.

[/CODE]


Hope that makes sense, perhaps it is not possible?

[davidrias]

Is that a bad image type to use? I can post a different type.