Reference in charts

[Guest]

I'm trying to reference a active worksheet in a chart but I keep getting
error messages. On the series tab of step 2 of the chart making process, I
would like to substitute the current worksheet instead of the permanent one
already in there.

Instead of ='Testing_Macro'!$A$1:$A$20

I want Testing_Macro replaced with a reference to an active sheet name. Any
ideas?

 

[Andy Pope]

Hi,

Something more like this.

="'" & activesheet.name & "'!$A$1:$A$20"

If the chart sheet is the activesheet this will fail.

Cheers
Andy