Searched the forums for similar issues and I cannot seem to work this out.

If I put this in a cell it works fine

=VLOOKUP(B3,DateRange,2,0)

If I tell VBA to write that formula, it works fine.

`ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-44],DateRange,2,0)"`

If I put this in VBA:

`Range("AK1").Value = Application.VLookup(Range("B3").Value, Range("DateRange"), 2, False)`

I get #N/A. I'm stumped - any ideas why this would happen, or how I can work this into my code? I need the vlookup to occur 1000s of times, and don't want to have to put the formula in the spreadsheet because I just want the results, not the formula.