Hi,

I keep getting an error when trying to use this line of code - any ideas? VBA doesn't like the apostrophes.

  Sheets("Transactions").Range("F2").Value = "=IFERROR(VLOOKUP(C2,VLookUp!$A$29:$B$37,2,FALSE)," ") "