On Oct 22, 3:15 pm, JE McGimpsey wrote:
Not so strange if my supposition is correct about RC addresses. An
A1-style address wouldn't trigger the bug.

In article .com,



bluegrassstateworker wrote:
This is certainly a bug. What is strange though is that I have a
similar name created range called:
A200_Office_of_Legislative_and_Public_Affairs that is very similar to
the one rejected by Excel.- Hide quoted text -

- Show quoted text -

Here are name ranges Excel <rejected:
C100_Division_of_Program_Integrity
2000_Division_of_Protection_and_Permanency
3000_Division_of_Family_Support
4000_Division_of_Child_Support
6000_Division_of_Child_Care


Here are some it <accepted:
B000_Division_of_Staff_Resource_Development
G100_Division_of_Quality_Living
C000_Division_of_Service_Regions
W400_Div_Long_Term_Care_and_Comm_Altern
W500_Division_of_Hospitals_and_Provider_Operations

If I add: an preceeding underscore
(_C100_Division_of_Program_Integrity) then Excel accepts it. Any
workarounds to this bug?


Perhaps I am missing where these as a group of rejected and accepted
are dissimilar.