How does this line of code run?

  • Thread starter Thread starter Jay
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does this function works? 5
LINE INSERTION IN TEXT !!! 3
Excel Excel spreadsheets opening at top instead of bottom. 4
Access Running Balance in Access 1
Compiling and Late Binding 3
Delete all labels on a line chart 1
Run Code Line by Line 3
Tried and true copy code lines fail me here 7

Back
Top