sheet level range names in excel 2003?

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!