| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Function VB code error
I am trying to run the following code in a spreadsheet
Heading = Application.WorksheetFunction.VLookup(Leftvalue, Num_Heading, 2, False) The following error message comes up Run - time error '1004' Unable to get the VLookup property of the WorksheetFunction class. I have tried it with different functions and it still comes up. Running Excel 2000 Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet Function VB code error
Is Num_Heading a range? Is LeftValue a value (or a range containing a
value)? XL97 and MacXL's VLookup doesn't function well as a WorksheetFunction method. Instead, for these versions, you should use the older Application.VLookup. I believe this was fixed in XL00, though. In article , (Bob) wrote: I am trying to run the following code in a spreadsheet Heading = Application.WorksheetFunction.VLookup(Leftvalue, Num_Heading, 2, False) The following error message comes up Run - time error '1004' Unable to get the VLookup property of the WorksheetFunction class. I have tried it with different functions and it still comes up. Running Excel 2000 Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maxa function results in value error in worksheet | Excel Worksheet Functions | |||
| Worksheet autocalc with min function in error | Excel Worksheet Functions | |||
| Worksheet function match - run time error | Excel Worksheet Functions | |||
| The Help on the Excel Edate worksheet function contains an error:. | Excel Worksheet Functions | |||
| vba code for lookup worksheet function | Excel Programming | |||
![Bob[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
