Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I got a message its header is "name conflict"
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I switch from 1,2,3... back to A,B,C... column reference na | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
Change GETPIVOTDATA cell reference to A1 style | Excel Worksheet Functions | |||
R1C1 reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |