Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text value in range
I'm looking for an efficient method to search for a text value. I have
a named range. Let's say range = A7:A14. I want to check cells C7:C14 to find the first cell whose value matches a previously populated variable. It's possible that none of the cells have that value in it. It seems that I could use a for all loop but I can't seem to get the syntax right. I've already got a ton of named ranges. I'm trying to avoid setting up a bunch more. Any ideas?? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for specific text within last non blank cell in a range | Excel Worksheet Functions | |||
Search for Condition, Text based, Date Range, Occurrences | Excel Worksheet Functions | |||
Search range for text not in another range | Excel Discussion (Misc queries) | |||
Search Range for item in seperate range | Excel Programming | |||
Can Range.Find search a Cells' Text property? | Excel Programming |