VLookup function-Doesn’t it work in VBA?

I tried using Vlookup function in Excel VBA &, even though is shows up in both the Methods and the Completion listings, I couldn’t get Excel to recognize it as a VBA function. Has anyone used this function _sucessfully_ in Excel VBA? mailto:malkor@moose-mail.com