Redefine name from another workbook

[Eric Hearn]

Book 1 uses the following data validation criteria to look up data in Book 2
' = INDIRECT("Codes") '.

If the list in Book 2 is expanded (or contracted) can Book 2 programmatically redefine the definition of 'Codes' in Book 1?

T.I.A.

Eric Hearn

 

[Damon Ostrander]

If Codes is the name of a range in Book 2, and the list Codes refers to expands or contracts, it is possible to have Book 1 redefine the name to correspond to the desired range. But it ishould be easier to make Codes a dynamic named range in Book 2 such that it automatically adjusts to the length of the list as items are added or deleted. That way Book 1 will not have to do anything. If you are not familiar with dynamic named ranges, I recommend this site:

http://www.beyondtechnology.com/geeks007.shtml

Damon

 

[Eric Hearn]

Hi Damon

Thanks for the pointer - it worked a treat!

Regards

Eric Hearn