Name Range not displaying in Name Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kvc - 04 Jan 2007 15:55 GMT

I created a worksheet a few months ago... that had a column with cells
that we gave a name. We referenced some formulas to this name range..
and everything worked out fine.

Yesterday.. I open the worksheet and highlight those exact cells to see
the name range.. and its no longer there... I also go to insert>name..
and theres aren't any names listed...

I go to my formulas.. and I do SEE the name range in the formula...

what happened to my name range?

Reply to this Message

Don Guillett - 04 Jan 2007 16:26 GMT

With ActiveWorkbook
.Names.Visible:=False 'true
End With

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I created a worksheet a few months ago... that had a column with cells
> that we gave a name. We referenced some formulas to this name range..
[quoted text clipped - 7 lines]
>
> what happened to my name range?

Reply to this Message

Dave Peterson - 04 Jan 2007 17:20 GMT

Don suggested that the names were hidden.

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It allows you to hide/unhide existing names.

If they're not deleted, this may make your life easier.

> I created a worksheet a few months ago... that had a column with cells
> that we gave a name. We referenced some formulas to this name range..
[quoted text clipped - 7 lines]
>
> what happened to my name range?

Signature

Dave Peterson

Reply to this Message

kvc - 04 Jan 2007 17:35 GMT

sorry i'm not familiar with programming.. but just need to know why
this happens? All my other workbooks are fine.. with name ranges.. and
i'm the only person who has used this worksheet.

> Don suggested that the names were hidden.
>
[quoted text clipped - 19 lines]
> >
> > what happened to my name range?

Reply to this Message

Dave Peterson - 04 Jan 2007 17:44 GMT

I've never seen names get deleted -- well, except when I delete them.

Are you saving the workbook as a normal workbook? If yes, I don't have a guess.

If you're saving as .prn or .csv, then these files are plain old text
files--they don't contain formatting, formulas, or names (or a lot of other
stuff).

> sorry i'm not familiar with programming.. but just need to know why
> this happens? All my other workbooks are fine.. with name ranges.. and
[quoted text clipped - 27 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Rate this thread: