I get Run-time error '1004': Unable to get the VLookup property of the WorksheetFunction class on the VLookup line. Column H is formatted as date.
Dim intRow As Integer
Dim dteMax As Date
intRow = Worksheets("Customer Product Export").Range("L" & Rows.Count).End(xlUp).Row...