VBA Lookup with different sheets

[dunnes]

Hi,
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"
Any ideas.....


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

cheers
Mike