Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / July 2006



Tip: Looking for answers? Try searching our database.

Problem with Insert "Name-Define"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michelle York - 22 Jul 2006 04:16 GMT
I'm having a recurring problem with a couple of the Names that I'm trying to
define.  

I have an excel Workbook that contains several different worksheets.  I'm
trying to create a hyperlink from a cell on one worksheet to a cell on
another worksheet.  I'm created and defined the names for many of the cells
already--"A", "B", etc--all the way to Z.  These are the names because it's
a listing of books by their Alphabetical difficulty level.  (Every book has
a level denoted by A-Z).

I've successfully defined names (and then easily hyperlinked to them) for
all but two letters.  Consistently the "C" and "R" cells will not let me
define their names.  It keeps saying "That name is not valid".  I'm doing
absolutely nothing different for these two than I did any other letter.  The
only way that I could get it to work is by defining them as "C_" and "R_".

Any idea why these two won't work the correct way?

Running Office 2004 (latest update with exception of the 5th.)  Working on a
G4 Powerbook with OS 10.3.9.
Ken Johnson - 24 Jul 2006 09:41 GMT
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
Bob Greenblatt - 24 Jul 2006 12:50 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.