| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find the column you are in
Probably a simple answer to this, but I am doing a find using the
Range.Find function. It is looking in all cells. Goal is to get column A's value for the row that my string was found. How can I do this? Was thinking about using offset, but I cannot figure out how to get the column the string was found on. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the column you are in
Hi Rishi,
Dim Rng As Range, Rng2 As Range Set Rng = Range(....).Find(......................) If Not Rng Is Nothing Then Set Rng2 = Rng.EntireRow.Cells(1) End If --- Regards, Norman "Rishi Dhupar" wrote in message oups.com... Probably a simple answer to this, but I am doing a find using the Range.Find function. It is looking in all cells. Goal is to get column A's value for the row that my string was found. How can I do this? Was thinking about using offset, but I cannot figure out how to get the column the string was found on. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find the column you are in
I like it, thanks didn't know that existed.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
| Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
Hybrid Mode
