Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using lookup function in vba
I am trying to use the lookup function in my vba code. I'm using excel 2003.
Here is what I have so far, but it isn't working. I'm getting the error "unable to get the lookup property of the worksheet function class" Dim name As String name = Range("e800") Dim Start As Integer Start = Application.WorksheetFunction.Lookup(name, "Q800:Q881", "t800:t881") This last line is what is highlighted I'm kind of new to this stuff, so I realize this may sound simple, but I'm having trouble getting it to work and any help would be appreciated. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Lookup function and Sum function | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |