PDA

View Full Version : Solved: Define Name question



vzachin
11-12-2008, 04:51 AM
hi,

this is not a vba question.
i need to define a range and name it "AA1" but that doesn't work.

is there a workaround?



zach

GTO
11-12-2008, 05:11 AM
Greetings Zack,

Not to be blunt, but I believe the 'workaround' is to choose a different name. As there is a native name of AA1 (ie cell AA1), even if you 'rename' the cell, Excel stills 'remembers' it.

Sorry,

Mark

vzachin
11-12-2008, 07:17 AM
hi Mark,
i kinda realized that there was no workaround but i was "hoping"..
i ended up pointing the indirect to another cell which had a formula
=IF(A2="AA1","myAA1",A2)
i named my range "myAA1"

zach

david000
11-12-2008, 11:17 PM
Just as an aside note when you let Excel name the range using the Create Name from Selection option using the top row it creates "AA1_"