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