Validation over Files

  • Thread starter Thread starter John D O'Connor
  • Start date Start date
J

John D O'Connor

I am trying to use Validation with a Named Range list box but I can't get it
correct (if even it is possible)

For example, I have a Range named "Country" location in a file in the
following location- C:\My Documents\Atlas.xls - where the named range in
turn is in sheet1, is it possible to create a Validation with a list within
a file called "World.xls"??

Would be great to do it, thanks

John
 
John,

You can use a named range, but not in another workbook AFAIK.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
John

Check out Debra Dalgleish's site to get instructions for using a named range
from other(opened) workbooks.

Gord Dibben Excel MVP
 
Back
Top