Further to my last... having a few problems converting the lookup value to a range...
Here's what I have so far:
Application.WorksheetFunction.VLookup(sheets("Revised Data").cells(i, 1), Range("'[New Credit Control Register.xls]Data'!$A$1:$R$1430"), 18, 0)
I need to convert the first bit (Sheets("Revised Data").cells(i, 1)) to a range... but aren't sure of the syntax.
Can someone help?