Trouble with Tables

[Danry]

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

[protonLeah]

Try this one:

Please Login or Register  to view this content.

[JapanDave]

Try this

Please Login or Register  to view this content.

Edit: protonLeah beat me to it!