Using an Address Rather than a Text Value in a Formula Name

Can you post the formula that you tried?

Aladin

I was trying to create a sublist, as you recommended earlier, and enter an address in the Name Box rather than text to associate the sublist with an item in the main list. What I neglected to mention in my earlier question was that the main list (and sublists) are populated by using the Paste Special / Paste Link command to extricate information from another worksheet that is filled out by an operator. The information the operator fills out has the potential to be changed, so I wanted to use an address rather than the text value ... so that the sublist would still be associated with the value at that address, even if it changes.

Maureen,

We cannot enter an address in the Name Box. By the way, any name in that box is, as it were, an "address", and certainly not a text-value. The MLIST items are thus not text-values.

I have no idea how what you want can be achieved otherwise.
A possible solution would be that the Names in MLIST does not change.

Aladin

I was afraid of that! Thank you for your help!

Could be achieved with a VBA event procedure.