VLOOKUP problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in Excel 97.

I have the following vlookup function:

Cells(1, 1) = Application.WorksheetFunction.VLookup(strCurrentSchedDate, _
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.
 
Cells(1, 1) = Application.WorksheetFunction.VLookup(strCurrentSchedDate, _
Worksheets("NON WORKDAY").Range("A1:B35").Value, 2)

Glen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup still not working 2
Vlookup Error 0
VBA userform Vlookup Excel 1
Cant find VLookup property 5
Vlookup Error 3
VLookup error 4
VLookup in VBA Help Needed 9
Vlookup macro run time error 8

Back
Top