Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What would be the most efficient way using programming code to find all
instances of a text phrase within a selected range of cells? I'm using an Inputbox to capture the text to search for, and when the text is found, run whatever code I want, then find the next occurance, run my code, etc. After it's found the last occurance, stop. I'm finding that my code wants to keep going back to the start and continuously looping (I'm using a "For Each ItemFound in Selection" approach unsuccessfully so far). Thanks for any suggestions! -- Steve C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
losing text from text box when pasting selection to word | Excel Discussion (Misc queries) | |||
Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
Finding a date & Selection.End(xlDown) | Excel Programming | |||
finding empty selection | Excel Programming | |||
Finding Specific Text in a Text String | Excel Worksheet Functions |