I don't have a problem using the range, but I still get the run-time error 9,
subscript out of range when I use the line below:
Set lookuprng = Workbooks("PRProc").Sheets("Accounts").Range("A:F" )

I am NOT in that workbook when I execute the code, if that makes a difference?