Hi Michelle,
I'm guessing Excel has reserved C and R for Column and Row
respectively.
Ken Johnson
Michelle York - 24 Jul 2006 13:53 GMT
I guess that makes sense. I never thought about that--too bad there wasn't
a way around it. But making it C_ and R_ was simple enough.
On 7/24/06 3:41 AM, in article
1153730488.897117.212390@p79g2000cwp.googlegroups.com, "Ken Johnson"
<KenCJohnson@gmail.com> wrote:
> Hi Michelle,
>
> I'm guessing Excel has reserved C and R for Column and Row
> respectively.
>
> Ken Johnson
On 7/21/06 11:16 PM, in article C0E702BA.2A9A%teacher24_70@yahoo.com,
> I'm having a recurring problem with a couple of the Names that I'm trying to
> define.
[quoted text clipped - 16 lines]
> Running Office 2004 (latest update with exception of the 5th.) Working on a
> G4 Powerbook with OS 10.3.9.
Ken provided the reason in his response. However, you are also "flirting"
with trouble in assigning names that may become ambiguous in certain
contexts. For example, the name "A" may be confused with column "A". You
should really rethink the names you are using.

Signature
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Michelle York - 24 Jul 2006 13:57 GMT
The only thing that I could do to change it is to say "LevelA" instead of A.
I can't change the name itself, just the way I define it I guess.
Will this ever be an issue if the hyperlinks are the ONLY things I use
defined names for?
On 7/24/06 6:50 AM, in article C0EA2C2B.76997%bob@nospam.com, "Bob
Greenblatt" <bob@nospam.com> wrote:
> On 7/21/06 11:16 PM, in article C0E702BA.2A9A%teacher24_70@yahoo.com,
>
[quoted text clipped - 23 lines]
> contexts. For example, the name "A" may be confused with column "A". You
> should really rethink the names you are using.