That's it...........I'm never upgrading.

How presumptuous of MS to not include one of my favorite things.




On Fri, 18 Jul 2008 20:30:23 -0500, Dave Peterson
wrote:

This depends on the Tools|Options|Calculation tab|Accept labels in formulas
setting.

Since it was removed in xl2007, I guess MS didn't realize that you were one of
the few people who used this <vbg.



Gord Dibben wrote:

I've used the create names a few times to build a mileage matrix or similar.

city1, city2 etc. across the top and city_1, city_2 etc. down the side

Then =city4 city_12 retrieves the intersecting value.

Gord

On Fri, 18 Jul 2008 16:59:28 -0500, Dave Peterson
wrote:

I've never used it in real life. I don't remember it's there until the macro
has finished <vbg.

Dave wrote:

Hi DP,
Thanks for pointing that out. Didn't know that was an option. Much simpler
and tidier than a macro.
Regards - Dave.