In my experience, I've found that excel will find values in manually hidden rows
-- both via the userinterface and via code.

I wonder if your code isn't specifying all the parms that you need to make it
work. If you don't specify all the parms, then your code will inherit those
settings that the last user (or last piece of code) used.

(This may not help, but excel seems to ignore any rows that were hidden via
autofilter.)

And maybe your code could do the search, check to see if the found value was in
a cell where the row was hidden

if foundcell.entirerow.hidden = true then
'keep looking
else
'found it!
end if



Maury Markowitz wrote:

I have a very large spreadsheet that contains a number of inter-row
formulas. A number of rows have to be included in order to make the
formulas work, but should not be displayed on-screen. We simply hide
these rows, which to our users effectively makes them disappear.

I found, much to my dismay, that hidden rows do not get searched in
code lookups using .Find. No one was able to offer an explanation for
why this would be or how to avoid it, so I resorted to unhiding every
row, doing the find, then re-hiding. Yuck.

Now I find to my equal dismay that the interactive Find command DOES
search in hidden rows. This is precisely the opposite behavior that we
want.

So is there any way to make this skip hidden rows? Is there a pref
somewhere we can set?

Maury

--

Dave Peterson