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?