Solved: Info

[oleg_v]

Hi
Please help!
where can i get the information how to use"WorksheetFunction"
in vba with explanation and all available functions and examples

Thanks

[Paul_Hossler]

I've always found that the IntelliSense works well, and the Help example shows how to use it

Most of the functions you can use on the worksheet are also available, but you do need to pass parameters in VBA syntax

Type this and after the Worksheetfunction's dot the list of available functions shows


x = Application.WorksheetFunction.Vlookup(myVar, Worksheets("Sheet1").Range("A:Z"), 13, False)


Paul