Error 2042 using Excel Application.Match in VBA

Phil
Phil used Ask the Experts™
I am trying to use vba with Application.Match to find the following string "20191122 04:30:00".
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PhilPresident

Author

Commented:
I found a way to handle my issue. thanks
Group Finance Manager
You will probably find that using the VBA .Find method is much more effective.
PhilPresident

Author

Commented:
thank you very much
Roy CoxGroup Finance Manager
Pleased to help. You can also find multiple instances using .Findnext if required.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial