VLookup in VB?

Easily handled,

ans = application.vlookup(....
If Iserror(ans) Then
...

or

On Error
ans = WorksheetFunction.VLookup(...
On Error Resume Next

If IsEmpty(ans) Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norie" <Norie.1u4rif_1124654732.2064@excelforum-nospam.com> wrote in
message news:Norie.1u4rif_1124654732.2064@excelforum-nospam.com...
>
> Take a look at the WorksheetFunction method of the Application object.
>
> It let's you access most worksheet functions in VBA.
>
> By the way using Vlookup in VBA can sometimes be a problem, if errors
> are returned by the function VBA won't like it.
>
>
> --
> Norie
> ------------------------------------------------------------------------
> Norie's Profile:
http://www.excelforum.com/member.php...o&userid=19362
> View this thread: http://www.excelforum.com/showthread...hreadid=397602
>