| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Unable to get the Hlookup property" VBA
Can't get this to work. I am trying to look up a value in the first
dimension of an array called NumberSetArray. Keep getting the "Unable to get the Hlookup property" error. ?Application.WorksheetFunction.HLookup(7, NumberSetArray, 1, False) I know the array has a 7 in it first dimension as seen below. ?NumberSetArray(0,0) 7 Is the problem due to the third term in the Hlookup Function? Thanks EM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to get Pivot Tables Property of Worksheet Class "Error | Excel Programming | |||
| Hiding Rows Error - "Runtime Error 1004 - Unable to set the hidden property of the range class" | Excel Programming | |||
| Interop - "Unable to set the Color property of the Interior class" | Excel Programming | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| "Unable to get the Pivotfieldsd property of the Pivot Class" | Excel Programming | |||
Threaded Mode
