| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does this line of code run?
Application.Lookup(11, vrEITab)
Thanks, Jay |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
| Code to read file in reverse fast line by line | Excel Programming | |||
| Single line of code with line separator | Excel Programming | |||
| Code to delete a Line in a another code | Excel Programming | |||
| Continue line of VBA code on the next line | Excel Programming | |||
Linear Mode
