Link to home
Start Free TrialLog in
Avatar of sigalos
sigalos

asked on

Find in Excel!!!

Hi guys,
I have this routine to find a specific cell in Excel and
and does not do anything. It does not bring an error, but most importantly it does not take you to the cell with the matching string. Here

  if InputQuery('Find', 'Find What', sFind) then
    UViewErrors.ExcelApp.Cells.Find(sFind, EmptyParam, xlValues, xlPart,
                                    xlByColumns, xlNext, False, False);

Any ideas?

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Russell Libby
Russell Libby
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sigalos
sigalos

ASKER

Very good. It is exactly what I wanted. Thank you.
Talk to you soon.