| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Object instead of value using HLookup
Hello,
I am trying to get a cell selected based on the Hlookup function in VBA: Application.WorksheetFunction.HLookup(Range("a1"), Range("B34:D85"),2, False) But I can get only the value. I am sure there is a simple way to do it. I just do not seem to be able to find it. Any suggestion would be welcome. Thanks -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
| How do I hlookup a text document object and then display it? | Excel Worksheet Functions | |||
| Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
| Option button object proeprties or object not found in vba | Excel Programming | |||
| Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Threaded Mode
