ExcelBanter - VLOOKUP problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP problem (https://www.excelbanter.com/excel-programming/324434-vlookup-problem.html)

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

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

Glen

"SHIPP" wrote in message
...
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