Invalid Range Names

Excel 2000 -

I am trying to assign Range Names as four character combinations. I have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?

For one thing.........AA83 is a cell address..........you could use AA_83 as
a RangeName


Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" <oldmusiclover@musiclover.com> wrote in message
news:13gEe.3090$6f.2183@newsread3.news.atl.earthlink.net...
> Excel 2000 -
>
> I am trying to assign Range Names as four character combinations. I have
> noticed that some are not valid.
>
> Example "aaa3" is valid but "aa83" is not.
>
> Why? Are there some naming restrictions?
>
>

You were right on the money! Thanx, you just saved me a ton of time.


"CLR" <croberts@tampabay.rr.com> wrote in message
news:Ohtfx0xjFHA.320@TK2MSFTNGP09.phx.gbl...
> For one thing.........AA83 is a cell address..........you could use AA_83
> as
> a RangeName
>
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Old Music Lover" <oldmusiclover@musiclover.com> wrote in message
> news:13gEe.3090$6f.2183@newsread3.news.atl.earthlink.net...
>> Excel 2000 -
>>
>> I am trying to assign Range Names as four character combinations. I have
>> noticed that some are not valid.
>>
>> Example "aaa3" is valid but "aa83" is not.
>>
>> Why? Are there some naming restrictions?
>>
>>
>
>

You're welcome............happy to help

Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" <oldmusiclover@musiclover.com> wrote in message
news:ukgEe.15544$aY6.10111@newsread1.news.atl.earthlink.net...
> You were right on the money! Thanx, you just saved me a ton of time.
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:Ohtfx0xjFHA.320@TK2MSFTNGP09.phx.gbl...
> > For one thing.........AA83 is a cell address..........you could use
AA_83
> > as
> > a RangeName
> >
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Old Music Lover" <oldmusiclover@musiclover.com> wrote in message
> > news:13gEe.3090$6f.2183@newsread3.news.atl.earthlink.net...
> >> Excel 2000 -
> >>
> >> I am trying to assign Range Names as four character combinations. I
have
> >> noticed that some are not valid.
> >>
> >> Example "aaa3" is valid but "aa83" is not.
> >>
> >> Why? Are there some naming restrictions?
> >>
> >>
> >
> >
>
>

aa83 is a cell in the sheet, you won't be able to use a two letter-two number
combination unless it's IW or higher

"Old Music Lover" wrote:

> Excel 2000 -
>
> I am trying to assign Range Names as four character combinations. I have
> noticed that some are not valid.
>
> Example "aaa3" is valid but "aa83" is not.
>
> Why? Are there some naming restrictions?
>
>
>