Hello Excel VBA Experts,
I have a formula that I use in Excel and it's working.
The formula below basically returns me EITHER the ROW INDEX of approximate match (via vlookup) OR #N/A (which means there's no approx. match)
My question is, when I tried to mimic the same formula above to VBA, it's giving me a "Run-time error '13' Type Mismatch".Please Login or Register to view this content.
Below is part of the VBA code.
May I know how do I get it to work like the excel function formula?Please Login or Register to view this content.
Thanks
Bookmarks