E
ExcelMonkey
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
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