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:
Private Sub FindRegionName()

    
    Dim LastCell
    Dim Table
    
    
    Workbooks.Open Filename:="J:\Planning & Resources\Portfolio Office\Finance\Budget 2012\Management reports 2012\International\Regional Report Names.xls"

    Range("A1").Select
    
    Selection.End(xlDown).Select
    Selection.End(xlToRight).Select
    
    RCode = Range("a2").Value
        
    LastCell = ActiveCell.Address

    Table = ("A1:" & LastCell)
    
    RName = Application.WorksheetFunction.VLookup(RCode, Table, 2, False)

    ActiveWorkbook.Close

End Sub
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