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
Bill Martin - 24 Jan 2008 22:08 GMT
Now I understand. I misread the Help system. Moving right along...
Bill
----------------
>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
[quoted text clipped - 14 lines]
>
> Bill