Reference in charts

[Chris]

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

Chris wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info