Hi
I just would consider this porperty buggy and nearly useless :-)

--
Regards
Frank Kabel
Frankfurt, Germany


keepITcool wrote:
it aint that simple...

ReferstoLocal argument of the Names.Add method
does NOT accept local formulas...

it accepts local FUNCTIONS but needs USenglish
separators and references.




www.XLsupport.com | keepITcool chello nl | amsterdam

Bob Phillips wrote in message
:

RefersToLocal is another property thatyiu could use rather than
Refersto, if the formula is in local language.

You need to rfefrence the range, but it can be shortcut with

Activecell.Name:="Hold1"