Take a look at
http://xldynamic.com/source/xld.Names.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jim May" wrote in message
...
Thanks Bob (and of course Dave..) -- This helps me to progress
through things - after following your instructions I "look-back" and
see that in creating such a sheet-specific range-name - it once
created is only visible from the "home" sheetname, and not the others.
If In a VBA routine I were to Refer to these rangenames do I need
to do anything SPECIAL to Read them (being Sheet Specific)?
Thanks for your help..
Jim
"Dave Peterson" wrote:
Just a typo:
'Master Sheet1!myName
should be:
'Master Sheet1'!myName
(an additional apostrophe)
Bob Phillips wrote:
When naming the range name, precede it with the sheet name, such as
Sheet1!myName
or
'Master Sheet1!myName
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Jim May" wrote in message
...
How is this done?
--
Dave Peterson