Range("A12").Value = Application.HLookup(1, "H12:EZ12", 1, T

[mmartens]

I am in VB and trying to run the following using the excel function hlookup

Range("A12&quot.Value = Application.HLookup(1, "H12:EZ12", 1, True)

but my out put is

Range("A12&quot.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

 

[joerd]

The second argument of HLOOKUP must be a range, not a string variable, so:
Range("A12&quot.Value = Application.HLookup(1, Range("H12:M12&quot, 1, True)

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[SGF1]

hlookup is a worksheet function, try:
Range("A12&quot.Value = Application.worksheetfuntion.HLookup(1, Range("H12:M12&quot, 1, True)

Cheers