Hi Guys,

I have a Workbook (say workbook x) with two sheets in it - Sheet1 and
Sheet2
Sheet 1 has been copied from another workbook (workbook y) into the
workbook x, and has various named ranges.
Sheet 2 is blank

Within Workbook x:
In Sheet 2 when I try and refer to a named range in sheet1, it tells
name can not be found.

If I look at the names in sheet1 I can see all the Names correctly
displayed (and behind them they list the sheet name, as if they relate
only to the sheet)
If I look at names in sheet2, there are no names defined.

Normally, names are visible in all the sheets within a workbook. How
can I make mine so....?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

This sounds like the names are sheet names not workbook names, that is they
are defined specifically to one sheet.

You can either create another name that is not worksheet specific and delete
the other, or refer to the worksheet name like so =Sheet3!myName.

Also take a look at http://www.xldynamic.com/source/xld.Names.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Darin Kramer" wrote in message
...
Hi Guys,

I have a Workbook (say workbook x) with two sheets in it - Sheet1 and
Sheet2
Sheet 1 has been copied from another workbook (workbook y) into the
workbook x, and has various named ranges.
Sheet 2 is blank

Within Workbook x:
In Sheet 2 when I try and refer to a named range in sheet1, it tells
name can not be found.

If I look at the names in sheet1 I can see all the Names correctly
displayed (and behind them they list the sheet name, as if they relate
only to the sheet)
If I look at names in sheet2, there are no names defined.

Normally, names are visible in all the sheets within a workbook. How
can I make mine so....?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks!!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!