Simple question!

Does anyone have any idea why this line does not work?

exchange_rate = Application.VLookup(currency_type, Workbooks("Rej
Reason Code Tracker.xls").Sheets("Exchange Rates").Range("R1:R65536"),
2, False)

It keeps returning an error.

Thanks for your help!

Peter