I am working in Excel 97.

I have the following vlookup function:

Cells(1, 1) = Application.WorksheetFunction.VLookup(strCurrentSc hedDate, _
Worksheets("NON WORKDAY").Range("A1").Value, _
Worksheets("NON WORKDAY").Range("B1"), 2)

When I run it I get the following error message:

Run time error 1004.

Unable to get the Vlookup property of the Worksheet function.

Any help would be greatly appreciated.
--
M. Shipp