VLookup problem
 

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!

VLookup problem
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


John C. wrote:
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!

VLookup problem
 

GROOVY!!!

Adding the range qualified fixed me.

THANX!