Dave,
sorry for the delay in responding to your answer. I have been out of
town doing of all things, , , , "Work",, (sorry for the use of the 4
letter word).

First of all, thanks for the help and info. I looked at Debra's web
pages and it gave me more info on how things work. But it was not the
problem.

The sheets had a lot of errors in the formula cells and I learned the
it was because they did not turn on any protection for any of the
formula cells. Over time, whoever was using the sheet would input
information in, it would not show up in the summary sheet, so they
would type over the formula cell. I had to go back several month
before I learned what they were doing wrong. Every error they had
started in an =countif cell where someone was adding a space behind
the information. When you looked at the information it look correct,
but car was car{space}, 4 letters, not 3.

I had to check every formula and then I protected everything but the
info input cell. Everything works for now.

Thanks again,

Ray



On Mon, 19 Apr 2004 21:55:20 -0500, Dave Peterson
wrote:

Does this mean that you can't find it, but it may still exist--or you looked and
it doewsn't exist?

If it's the first, Debra Dalgleish has some pictures at:
http://www.contextures.com/xlfaqMac.html#NoMacros
that may help locate macros.

If it's the second, I don't have another guess.

Ray wrote:

On Fri, 16 Apr 2004 22:27:49 -0500, Dave Peterson
wrote:

I've never seen excel do this.

Any chance your friend has a macro "helping out"?

Good idea, but I can not find any macro.

ray