Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default What is wrong with naming a cell as c?

Doh! Thanks for the clarification, vezerid. :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"vezerid" wrote in message
oups.com...
Hi Anne,

This is not true for single-letter names. In the past I have
successfully named cells as "a" and "b" (w/o the quotes). It is
particularly nice as instructive technique when I want to use Excel for
demo of linear function behavior. Afterall, a cell's original name
cannot be letter only, since we need the column number as well, so no
conflict there...

And as I was writing just this I realized... and tested... It conflicts
with the R1C1 notation. So, similarly the leter "r" and the string "rc"
cannot be used as names. All other single letters can (probably...)

Regards,
Kostis



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming sheets from a cell value Tony4X4 Excel Discussion (Misc queries) 12 September 7th 09 01:55 PM
If Statement linked to cell with VLOOKUP problem - getting wrong v Mike R. Excel Worksheet Functions 4 January 14th 06 02:16 PM
Result in Cell is Wrong Lilbit Excel Worksheet Functions 1 June 23rd 05 05:19 PM
Naming a cell mike Excel Worksheet Functions 2 January 12th 05 11:31 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"