I was about to embark on moving some VLOOKUP type code into a VBA module
using the "WorksheetFunction" approach. First however, I thought I'd check
whether there was an easier, more direct approach.

Following my nose, I find the VBA development help system provides a list of
available native VBA functions which include LOOKUP so I don't have to mess
with the "worksheetfunction" approach. Wonderful.

I follow the VBA help system for syntax and plug it into a VBA module. VBA
provides a compile error though "Sub or Function not defined".

What's going on? The VBA help system helpfully describes the function but
the compiler does not recognize it. Do I need to link to something? I've
never stumbled across such a thing in VBA before.

Thanks.

Bill

Now I understand. I misread the Help system. Moving right along...

Bill
----------------
"Bill Martin" wrote in message
...
I was about to embark on moving some VLOOKUP type code into a VBA module
using the "WorksheetFunction" approach. First however, I thought I'd check
whether there was an easier, more direct approach.

Following my nose, I find the VBA development help system provides a list
of available native VBA functions which include LOOKUP so I don't have to
mess with the "worksheetfunction" approach. Wonderful.

I follow the VBA help system for syntax and plug it into a VBA module.
VBA provides a compile error though "Sub or Function not defined".

What's going on? The VBA help system helpfully describes the function but
the compiler does not recognize it. Do I need to link to something? I've
never stumbled across such a thing in VBA before.

Thanks.

Bill