Tag Archives: CLng

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 date as the lookup_value. … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , | 4 Comments