NameBox defintions

S

sachin.sharma

I have about 7 worksheets. Each one needs the same name definition for a specific range of cells, such as personnel.aug. The problem is that for my seventh worksheet, every time I try to insert a name for a range of cells, this erases the name from the sixth worksheet. Yet, all the other worksheets are still the same, only the sixth one gets its name removed. Also, the I have to insert the name is through the toolbar, Insert, Name, Define... I want to insert through the name box next to the formula box in the toolbar. But, for instance, in worksheet 7, if I insert the name through the name box in the toolbar, the name doesn't get inserted, instead it directs me to where the last name was defined in worksheet 6. Does anyone know what's going on? Thanks in advance.
 
D

Don Guillett

try preceding the name with the sheet
sheet1!myname

--
Don Guillett
SalesAid Software
[email protected]
sachin.sharma said:
I have about 7 worksheets. Each one needs the same name definition for a
Click to expand...
specific range of cells, such as personnel.aug. The problem is that for my
seventh worksheet, every time I try to insert a name for a range of cells,
this erases the name from the sixth worksheet. Yet, all the other worksheets
are still the same, only the sixth one gets its name removed. Also, the I
have to insert the name is through the toolbar, Insert, Name, Define... I
want to insert through the name box next to the formula box in the toolbar.
But, for instance, in worksheet 7, if I insert the name through the name box
in the toolbar, the name doesn't get inserted, instead it directs me to
where the last name was defined in worksheet 6. Does anyone know what's
going on? Thanks in advance.
 
D

Don Guillett

Let me re-phrase that for clarification. I have done this for a custom zoom
formula.

insert>name>defined names >myname>refers to: =sheet!$a:$L
 
Top