Thanks, but I don't think that's the problem. The names don't appear in Name
Manager even with all the filters off. Plus, I get an error when the macro
tries to go to the named range.

"Dave Peterson" wrote:

There are some names that won't appear in the namebox. And some names can be
marked as not visible.

Any chance you're seeing one of these?

Just curious...

What is the name that's disappearing and what does it refer to? Maybe someone
running xl2007 will notice a problem with more info.

Daryl Fagala wrote:

In at least one Excel 2007 macro-enabled workbook, names I give to certain
cells or ranges disappear from the list in the Name dropdown box as well as
Name Manager when I close and then re-open the workbook. I've been careful to
make sure I save the workbook each time I create a name but they still
disappear on re-opening. Is anyone else having this problem and, if so, found
the solution?

--

Dave Peterson