How does this line of code run?
 

Application.Lookup(11, vrEITab)

Thanks,
Jay

How does this line of code run?
 

It runs pretty well in context:

Sub zeroo()
Dim vrEITab As Range
Set vrEITab = Range("A1:A10")
Range("A5").Value = 11
x = Application.WorksheetFunction.Lookup(11, vrEITab)
MsgBox (x)
End Sub

will display the desired 11
--
Gary''s Student - gsnu2007k


"Jay" wrote:

Application.Lookup(11, vrEITab)

Thanks,
Jay