Weird Range Name Issue

[Roncondor]

I have used range names for over 10 years

However, I have a weird situation that I have not seen before and don’t seem to find on any postings anywhere on the internet.

I define a range name and two odd situations occur:
1. when I reference that range name in a formula, it becomes a RELATIVE reference NOT ABSOLUTE unless I put a “$” in front of the name. [This is how Lotus used range names].
2. When I go to edit a formula with the range name, the range name in the formula mysteriously disappears and the cell formula (e.g. “$A$1”) shows up instead.

I can send you a sample file showing the issue

The first/best solution wins a $50 donation to the non-denominational charity of your choice. (subject to mutual approval)

Thanks
Ron

 

[AlphaFrog]

Thank you for your gift in support of the work of Water.org.
Your gift will help to save lives and bring us closer to the day when everyone in the world can take a safe drink of water. Be assured, your gift will truly make a difference in the lives of others.
GIFT INFORMATION:
Amount: $50.00
Date: 12/26/2013

Cool and thank you. You're a man (person) of honor.