Thanks once again Bob.

I particularly like the Names dropdown widening procedure as this has been a
pain in a number of workbooks for a while.

However, I tried adding it as a Workbook Open event to my Personal.XLS file
and it seems to get upset with the Public Declare parts at the top. Error:

"...Declare statements not allowed as Public members of object modules"

Does this mean I have to stick this in a class module first (or at least the
Declare elements)?

Regards

John

"Bob Phillips" wrote in message
...
You can also select the range, and type the name directly into the names
box, to the left of the formula bar.

You might want to learn a bit more at
http://www.xldynamic.com/source/xld.Names.html

--

HTH

RP