At the end of the post I said

in a module put in

variant

highlight it and hit F1

--------------

Insert = Name = Define

when you assign the name, use the sheet name as well

name: Sheet1!MyName
Refersto: =Sheet1!$A$1:$A$10

as an example.

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
can you show me how can I get this help?
Do you know how to assign a name locally to a range in a sheet. I know
how to do it globally with Insert-Name-Define but dont know how to
define a local name for a range.
XS