runtime 438 with vlookup worksheetfunction

[williams485]

Hello Excel Forum,
I'm writing a macro that populates a list then uses a vlookup to retrieve a value from another worksheet - pretty straightforward. But, I get Runtime error 438 (Ojbect doesn't support this property or method) on the line containing the worksheetfunction. I've typed the "application.worksheetfunction" line into the Immediate window and the expected result was printed. So, I can't figure out why I get the error. Any help will be much appreciated.

Please Login or Register  to view this content.

Thanks

[williams485]

I've spotted my spelling mistake (no 'c' in worksheetfunction). Apologies to anyone that has taken the time to read this thread...