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!