See Debra Dalgleish's site for instructions.
http://www.contextures.on.ca/xlDataVal05.html
Note that source workbook must be open.
Gord Dibben MS Excel MVP
On Sun, 17 Dec 2006 07:40:01 -0800, vassilis
wrote:
Hi
i need some help to define a range of cells that belong into a different
book and a different sheet...
I named an area AA into a AA.xls...and i want to make this area my source
into BB.xls for my drop down list...
Thanks