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
|