| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select row (with offset) from VB formula result
Setup: I have just finished running a HLOOKUP and have a result = res,
which is a date value which matches an existing date cell on row 1. What is the VB code to select that matching cell, then offset down one row and select the remainder of the column? Thanks, Randy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select row (with offset) from VB formula result
CORRECTION: Title should read "Select COLUMN .... " Sorry! - Randy
"RAP" wrote: Setup: I have just finished running a HLOOKUP and have a result = res, which is a date value which matches an existing date cell on row 1. What is the VB code to select that matching cell, then offset down one row and select the remainder of the column? Thanks, Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset/Match when there is more than 1 result | Excel Worksheet Functions | |||
| Offset a formula result | Excel Worksheet Functions | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
| Select and Copy Range using Offset | Excel Programming | |||
Hybrid Mode
