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.