Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A function to find a phrase within a range of cells and return the address of the first instance.
I have been trying to write a UDF that takes a cell range and a string
as inputs. It then checks each cell in the supplied range for the string returning the address (i.e. $A$6) of the first instance. I won't embarass myself by putting any of my attempts here. Finding and selecting the cell seems easy to do as a sub-routine but I've struggled mightily to do this as a function. I'd really appreciate any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find first and last cells in range, return info beside | Excel Worksheet Functions | |||
Find a value in an array and return cell address | Excel Worksheet Functions | |||
Function to return a range of cells from a PivotTable | Excel Worksheet Functions | |||
Find 2nd instance of a word in a range. | Excel Worksheet Functions | |||
Function to return the latest non-zero value in a range of cells . | Excel Worksheet Functions |