| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Lookup address
I need to be able to look up a cell address.
I can lookup the value using Application.worksheetfunction.vlookup bu I need the address. If this data A 3 B 4 C 5 were in the range A1:B3, and the lookup value was in column A, I nee to know the address of the cell in the same row in column B. I figured out a way to do it in Excel, but it doesn't work in VB because it uses the CELL function which isn't in the WorksheetFunctio object. Any help is appreciated. Thanks -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup an address in a worksheet | Excel Discussion (Misc queries) | |||
| Lookup Cell Address | Excel Worksheet Functions | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Finishing my Address Lookup | Excel Discussion (Misc queries) | |||
| Celll Address Lookup | Excel Worksheet Functions | |||
Threaded Mode
