Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, T
Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, T
(OP)
I am in VB and trying to run the following using the excel function hlookup
Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, True)
but my out put is
Range("A12").Value = error 2015
can any one see what is wrong. I am at the end on my rope I am not sure what to try
thanks
Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, True)
but my out put is
Range("A12").Value = error 2015
can any one see what is wrong. I am at the end on my rope I am not sure what to try
thanks





RE: Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, T
Range("A12").Value = Application.HLookup(1, Range("H12:M12"), 1, True)
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, T
Range("A12").Value = Application.worksheetfuntion.HLookup(1, Range("H12:M12"), 1, True)
Cheers