I switched on the R1C1 reference style but I can't switch it off a
 

I got a message its header is "name conflict"

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