I created a vlookup VBA code and it works:
My problem is, the cell returned 40262 for 25-Mar-10.lRow = Range("A:A").Find(what:="*", LookIn:=xlValues, SearchOrder:=xlByRows, _ searchdirection:=xlPrevious).Row Range("E2:E" & lRow).Formula = "=vlookup(C2,etc!A:B,2,False)" End With
How will I add formatting on my code?