Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get the Vlookup Property of the WorkSheetFunction Class
(RunTime Error 1004)Unable to get the Vlookup Property of th
WorkSheetFunction Class is the error I get when I try to run Range("i23", "i23").Value = WorksheetFunction.VLookup(ComboBox2.Text Worksheets("Turbine").Range("A67:x127"), 2, False) It works a few times, then stop -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get the Vlookup Property of the WorkSheetFunction Class
Hi
try: Range("i23").Value = WorksheetFunction.VLookup(ComboBox2.Text, Worksheets("Turbine").Range("A67:x127"), 2, False) -- Regards Frank Kabel Frankfurt, Germany (RunTime Error 1004)Unable to get the Vlookup Property of the WorkSheetFunction Class is the error I get when I try to run Range("i23", "i23").Value = WorksheetFunction.VLookup(ComboBox2.Text, Worksheets("Turbine").Range("A67:x127"), 2, False) It works a few times, then stops --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get the Vlookup Property of the WorkSheetFunction Class
That is because it doesn't find the value in Combobox2.text more than
likely. Try it this way Dim var as Variant var = Application.VLookup(ComboBox2.Text, _ Worksheets("Turbine").Range("A67:x127"), 2, False) if iserror(var) then Range("I23").Value = Combobox2.Text & " not found" else Range("I23").Value = var End if -- Regards, Tom Ogilvy "monagan " wrote in message ... (RunTime Error 1004)Unable to get the Vlookup Property of the WorkSheetFunction Class is the error I get when I try to run Range("i23", "i23").Value = WorksheetFunction.VLookup(ComboBox2.Text, Worksheets("Turbine").Range("A67:x127"), 2, False) It works a few times, then stops --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to get the pivotfields property of the pivottable class | Excel Discussion (Misc queries) | |||
"Unable to get the VLookup property of the WorksheetFunction class | Excel Discussion (Misc queries) | |||
"Unable to get the NormSInv property of the WorksheetFunction clas | Excel Worksheet Functions | |||
Unable to set the Locked property of the range class | Excel Programming |