Re: using VLookUp in a VBA program

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 02/13/04 

Date: Fri, 13 Feb 2004 00:38:43 -0700

Actually, in several versions of XL (at least XL97, all MacXL versions
and, IIRC, XL00) VLookup was not implemented correctly into the
WorksheetFunctions collection, and WorksheetFunction.VLookup does not
work. Using the older Application.VLookup is still supported and works
in all versions.

In article <uHjvFZf8DHA.1816@TK2MSFTNGP12.phx.gbl>,
 "Rob van Gelder" <newsgroups@nojunkmail-vangelder.co.nz> wrote:

> It's a Typo. I'm sure Tom meant:
> WorksheetFunction.VLookup

Quantcast