Wishing all a happy new year ...
I get a runtime error with this piece of code:
junk = Application.WorksheetFunction.VLookup("Min", table,
Application.WorksheetFunction.Match("Gorge", top, 0))
junk is variant, table and top are ranges.
The error is:
"Unable to get the Match Property of the WS function"
If I replace the ref to App.WSF.Match with an integer, it works fine.
Thoughts?
Thanks, Tony
Bookmarks