Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error '1004' in WorksheetFunction
Greetings to all, First off, I would like to thank anyone who can help me. I appreciat your effort and your time. When I run the procedure below, I get a run-time error 1004 with th following message "Unable to get the VLookup property of th WorksheetFunction class". I started by typing the code and then chose to use the pull down men for the property in hopes that this would fix the error. However, i did not work. I am greatful for any assistance. Sub Get_NY_Contract() Dim Contract As Variant Dim Flow As Double Contract = InputBox("Enter NY Contract Number") Sheets(1).Activate Flow = WorksheetFunction.VLookup _ (Contract, Range("E:I"), 5, False) MsgBox Contract & "DA" & Flow End Su -- oakma ----------------------------------------------------------------------- oakman's Profile: http://www.excelforum.com/member.php...nfo&userid=917 View this thread: http://www.excelforum.com/showthread.php?threadid=31436 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.WorksheetFunction error | Excel Discussion (Misc queries) | |||
Excel 2003 WorksheetFunction Functions run-time error | Setting up and Configuration of Excel | |||
Worksheetfunction.vlookup and #value error | Excel Worksheet Functions | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming |