After playing with it a little, I think you are right, I just assumed he was
selecting the hidden cell (which he obviously is not - I got ahead of myself).

Thanks Tom!

"Tom Ogilvy" wrote:

I have had a different experience.
In my experience if you use the parameter
Lookin:=xlFormulas
it finds the hidden cell.

Lookin:=xlValue
it doesn't

That would be consistent with your experience since you don't explicitly set
it and this is one of the persistent settings.

I wouldn't discount Dave Peterson's experience, but then again he may have
never really studied the problem.

--
Regards,
Tom Ogilvy


"achidsey" (notmorespam) wrote in message
...
Excel Experts,

At the end of a number of modules in my code, I find specific text, and in
the cell to the right, enter the text "DONE". An example would be:

Cells.Find(What:="Save GS Files").Offset(, 1).Select
Selection.Value = "DONE"

Generally, I hide the column that contains the text that the cells.find
looks for. Generally this doesn't cause a problem, but sometimes this
part
of the code fails, and to get it to work I have to unhide the column that
hold the text.

Is this a known problem where a cells.find command can't find text in a
hidden cell or is this an unusually/bug type situation? Or should I be
adding some additional parameters to the cells.find command?

Thanks,
Alan


--
achidsey