PDA

View Full Version : Solved: Renaming a Range



Marcke
12-02-2008, 03:46 AM
I renamed 6 ranges, but apparently one ends in Number in stead of Nr.

The stupid thing is each time i change Number to Nr, Excel changes it back. What am I doing wrong?

Bob Phillips
12-02-2008, 03:47 AM
How are you chaning it?

Marcke
12-02-2008, 03:51 AM
I was going to the right top area, editing the text, and then pressing enter.

I allready fixed it by cutting a cell, pasting it on the spot, and renaming the cell.

Thanks for the quick reply though!

Marcke
12-02-2008, 03:52 AM
Damn, i was too quick. Now the cell keeps being named K4 and not the XXXNr I wanted it to be.

Jan Karel Pieterse
12-02-2008, 03:54 AM
Check your Tools, Autocorrect settings.

Bob Phillips
12-02-2008, 03:56 AM
I was going to the right top area, editing the text, and then pressing enter.

How does that change the defined name?

Bob Phillips
12-02-2008, 03:57 AM
You would do well to get hold of Jan Karel Pieterse's NameManager utility, http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp, it makes managing names so simple.

Marcke
12-02-2008, 03:58 AM
Didn't change anything, I still get the same problem.

Marcke
12-02-2008, 04:08 AM
Problem changed. Removed all ranges then tried this again.