having a sligh problem with a vlookup in VBA.
The vlookup is below
Set rng = shLookup.Range("a2:b5")
SheetPassword = WorksheetFunction.VLookup(ActiveSheet.Range("ab3"), rng, 2, 0)
shLookup in in the current workbook and seems ok
So the vlookup is looking up a value from a seperate workbook and finding this value in the same workbook as the vba code/
When i run the code an error message occurs saying "Unable to get the vlookup property of the Worksheet Function class"
also my pc seems to be missing the mainxl.hlp file any ideas where i can find this, i am going to search tho while i await a reply