You can either unhide all the columns/rows or you can loop through the usedrange
of each sheet.

I don't think that there's any middle ground.

Maury Markowitz wrote:

On Jul 3, 10:27 am, Dave Peterson wrote:
How about this suggestion??

If you have to have your own code, look at .findnext in VBA's help.

I did. However, MS, in their infinite wisdom, decided that .FindNext
will not look in hidden cells. The cells I'm looking for are, of
course, hidden. FindNext has all sorts of other problems too, I find
it to be generally unstable in terms of predictable behavior.

BTW, a text editor demonstrated that FlexFind also uses Find/FindNext.

Maury

--

Dave Peterson