series defined with sheet-level range name lose definiton when sheet is copied

**bagullo** · 11-18-2011, 06:40 AM

Hi, this is what I have

a template sheet that is copied as many times as required by a macro.

in order to avoid coding all chart definition I have some charts defined with sheet level range names.

My surprise is that when the sheet is copied, the new copy loses range name definition and are converted to values (which means nothing since it's just a template with no data). Looks like a bug to me (since formulas do update with new sheet range names).

I guess I'll have to redefine charts when sheet is copied, but wanted to check if anybody has faced a similar problem before and has found some awesome workaround.

thanks!

**pike** · 11-19-2011, 02:22 AM

hi bagullo
I think in 2003 you need to declare the sheet name

Test:=$a$1:$a$5
Sheet1!Test:=$a$1:$a$5

it been a while since i`ve use 2003

**bagullo** · 11-21-2011, 05:24 AM

Hi pike,

the sheet level range names are no problem. Indeed I declare then as you describe -- (not exactly convenient), the problem is in the chart series definition. Even as they work perfectly in the sheet template, as I copy it, the definition vanishes...

is that what you meant?