Are you saying that If I were to use:

myval1 = range("test1").value
myval2 = range("test1").value

That there might be a problem with
myval1 and
myval2 ?

Jim



"Dave Peterson" wrote:

You can use:

dim myVal1 as variant
dim myVal2 as variant

myval1 = worksheets("sheet1").range("test1").value
myval2 = worksheets("sheet2").range("test1").value

Same range name on different sheets--but fully qualified.

Jim May wrote:

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


--

Dave Peterson