Trouble with Tables

Hi,

I want my VBA to do a vlookup in another spreadsheet to find the name of the region for the report. However, I keep getting the following error message: "Run-time error '1004' Unable to get the Vlookup property of the WorksheetFunction class." The code is as follows:

Please Login or Register  to view this content.

I have tried to use the actual variable as a test and I still get the same error message so it's not that the variable isn't in the table.

Any suggestions?

Cheers,
Danry