I'm using very simple Vlookup function that is working very well in a
spreadsheet but in VB it says unable to get Vlookup property in
WorksheetFunction class.

Set rngLogIn = Worksheets("Main").Range("A9")

varName = Application.WorksheetFunction.VLookup(rngLogIn, LoginName, 3, False)

Can anybody help?

Thanks