Thread: Unable to get the Vlookup Property of the WorkSheetFunction Class
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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/

Reply With QuoteReply With Quote