View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz[_2_] Maury Markowitz[_2_] is offline
external usenet poster
 
Posts: 119
Default Finding every instance of a value in a multi-sheet workbook

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