Hi Guys,
i am using match as formula and works like a charm:
Screenshot_70.png
but when i am doing the same in code i am getting error 2042:
why?Please Login or Register to view this content.
Jacek
Hi Guys,
i am using match as formula and works like a charm:
Screenshot_70.png
but when i am doing the same in code i am getting error 2042:
why?Please Login or Register to view this content.
Jacek
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 08-02-2020 at 05:08 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
thank you sintek,
why this is working?
Jacek
Dates are tricky...Best to convert to long or double when doing a search....
This also works...
Please Login or Register to view this content.
Last edited by sintek; 08-02-2020 at 05:29 AM.
thank you!
Jacek
Glad I could assist...tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks