Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP problem
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem | Excel Discussion (Misc queries) | |||
Problem w/vlookup | Excel Worksheet Functions | |||
Vlookup problem | Excel Worksheet Functions | |||
VLookup Problem | Excel Discussion (Misc queries) | |||
Vlookup Problem | Excel Worksheet Functions |