View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Do NOT find in hidden rows?

You can show the edit|find dialog:

application.dialogs(xldialogformulafind).show

Maury Markowitz wrote:

I could likely emulate what I'm trying to do in code, but is there a
way to have my code run when the user hits Find and then still call
back into the Find dialog?

I don't think it's an inheritance issue. When I use .Find in code it
definitely skips any hidden rows, but when I Control-F and type in the
exact same string it goes directly to the hidden row.

Very annoying.

Maury


--

Dave Peterson