I am using Excel 2003 and tried to create a range name called
R5_Prop_util_lookup
I am getting the error that this is an invalid name. I can’t figure out why. Excel help does not provide the naming rules anywhere I can find. Anybody know?
Lose the apparent cell reference at the start of the name,
Maybe it doesn’t like the “R5” since it’s also the name of a cell?
This is cool. I had never known this, but playing arround with it, the answer is that Excel won’t let you name anything which would be a valid cell address. The problem is the R5. This can be seen by trying to name something A65536, which it won’t accept, but A65537, which is not a valid cell address, is acceptable. Rename it to RR5_Prop_util_lookup and it will work.
Excel does provide guidelines for naming. Go to Help, and under Index enter ‘name’ as the keyword. You should see a topic ‘Guidelines for naming cells, formulas, and contants in Microsoft Excel’. You can also get to this topic by using ‘guideline’ as the keyword.