sheet level range names in excel 2003?

**bagullo** · 05-09-2011, 05:01 AM

hi,

I am creating a workbook with graphs that would be best defined with (dynamic) range names (which refer to data in the same sheet), but the problem is that in the same workbook there will be almost identic 20 or so such sheets, so workbook level range names do not seem like a good idea

I worked breifly in xl2007 and there was easy to define sheet level range names, but did not see the possibility in xl2003 any ideas/workarounds?

thanks!

**teylyn** · 05-09-2011, 05:09 AM

Hello,

Use Insert > Name > Define
enter the name of the range like

Sheet1!MyRange

This way, the scope of the range name "MyRange" will be for Sheet1 only.

cheers,

**romperstomper** · 05-09-2011, 05:20 AM

I'd also suggest downloading JKP's free Name Manager addin from here.

**bagullo** · 05-10-2011, 05:00 AM

Originally Posted by romperstomper

I'd also suggest downloading JKP's free Name Manager addin from here.

thnks, but I'm in a completely locked environment where I can do next to no modifications to the environment...

**bagullo** · 05-10-2011, 05:02 AM

Originally Posted by teylyn

Hello,

Use Insert > Name > Define
enter the name of the range like

Sheet1!MyRange

This way, the scope of the range name "MyRange" will be for Sheet1 only.

cheers,

WOW, didn't know that -- Sweet!
I managed to create such names by VBA and use them in charts

--- it works great!
thnks!