Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
gello
 
Posts: n/a
Default I switched on the R1C1 reference style but I can't switch it off a

I got a message its header is "name conflict"
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default I switched on the R1C1 reference style but I can't switch it off a

That means you had a name that looked like a cell address.

If I'm in R1C1 reference style, I can name a range: B3

But if I want to switch back to A1 Reference style, then my name "B3" will
confuse excel. It has to have you change this to something that isn't an
address.

So if you want to change to A1 Reference style, you're gonna have to choose a
new name--something like: _B3 would work.



gello wrote:

I got a message its header is "name conflict"


--

Dave Peterson
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
How do I switch from 1,2,3... back to A,B,C... column reference na C. White Excel Discussion (Misc queries) 7 November 12th 08 05:48 PM
R1C1 reference style Peg P Excel Discussion (Misc queries) 2 November 15th 05 06:48 PM
Change GETPIVOTDATA cell reference to A1 style Doit Excel Worksheet Functions 1 October 5th 05 03:09 PM
R1C1 reference Tony S Excel Discussion (Misc queries) 1 May 10th 05 05:58 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:10 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"