MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Maureen Hill on November 15, 2001 2:13 PM

Is there any way to enter an address rather than a text value in a formula name? I'm getting an Invalid Name error.


Posted by Aladin Akyurek on November 15, 2001 2:21 PM

Can you post the formula that you tried?

Aladin

Posted by Maureen Hill on November 15, 2001 2:27 PM

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.


Posted by Aladin Akyurek on November 15, 2001 2:56 PM

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


Posted by Maureen Hill on November 15, 2001 3:26 PM

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


Posted by anon on November 15, 2001 3:47 PM

Could be achieved with a VBA event procedure.