calling colums in another sheet for vlookup

[michaelsg]

I've tried these three call formats, none work (runtime error)... what am I doing wrong? Thanks in advance

Application.WorksheetFunction.VLookup(Cells("A1").Value, Range("airport list!B:C"), 2, False)
Application.WorksheetFunction.VLookup(Cells("A1").Value, Sheets("airport list").Range("B:C"), 2, False)
Application.WorksheetFunction.VLookup(Cells("A1").Value, Sheets("airport list").Columns("B:C"), 2, False)

 

[michaelsg]

I've tried these three call formats, none work (runtime error)... what am I doing wrong? Thanks in advance

Application.WorksheetFunction.VLookup(Cells("A1").Value, Range("airport list!B:C"), 2, False)
Application.WorksheetFunction.VLookup(Cells("A1").Value, Sheets("airport list").Range("B:C"), 2, False)
Application.WorksheetFunction.VLookup(Cells("A1").Value, Sheets("airport list").Columns("B:C"), 2, False)

I found the correct syntax:

Application.WorksheetFunction.VLookup(Range("A1"), Worksheets("airport list").Range("B:C"), 2, False)