VLookup problem

J

John C.

I have a worksheet that contains data, corresponding to
various sample streams.

The data is arranged alpha/numerically. Column 1 has the
name of the sample stream, column 2 has the analyzer ID.

I have:

Sheets("Parameters").Select
MsgBox Application.WorksheetFunction. _
VLookup("FW1", "A2:B14", 2)


I continue to receive "Unable to get the VLookup property
of the WorksheetFunction class.

I have ensured that "Trust access to Visual Basic Project"
is enabled under macro security.

ANY ideas? Thankyou!
 
F

Frank Kabel

Hi
try
with Sheets("Parameters")
MsgBox Application.WorksheetFunction. _
VLookup("FW1", .range("A2:B14"), 2,0)
end with
 
Top