colinlegg.wordpress.com
Using WorksheetFunction.VLookUp To Look Up A Date In VBA
VLOOKUP is exposed in VBA via the WorksheetFunction class and works much the same as it does when you use it in a worksheet, but one thing you have to be careful of is when you have a dat…