| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search a range of cells for a specific word
I want to search every cell in a column until I get to a cell that has a
sentence that starts with the word "Disclaimer:" How would I write code for that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search a range of cells for a specific word
Use editfindfind"Disclaimer". Record a macro while doing
-- Don Guillett Microsoft MVP Excel SalesAid Software "Bishop" wrote in message ... I want to search every cell in a column until I get to a cell that has a sentence that starts with the word "Disclaimer:" How would I write code for that? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search a range of cells for a specific word
Actually what I was looking for is the VBA code.
"Don Guillett" wrote: Use editfindfind"Disclaimer". Record a macro while doing -- Don Guillett Microsoft MVP Excel SalesAid Software "Bishop" wrote in message ... I want to search every cell in a column until I get to a cell that has a sentence that starts with the word "Disclaimer:" How would I write code for that? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search a range of cells for a specific word
Recording the code while you do it manually may give you the code you want.
If you want to tweak it to make it nicer, post back with your current code. Bishop wrote: Actually what I was looking for is the VBA code. "Don Guillett" wrote: Use editfindfind"Disclaimer". Record a macro while doing -- Don Guillett Microsoft MVP Excel SalesAid Software "Bishop" wrote in message ... I want to search every cell in a column until I get to a cell that has a sentence that starts with the word "Disclaimer:" How would I write code for that? . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search range of cells for word & return value for use in formula? | Excel Worksheet Functions | |||
| Count Specific word in Specific range | Excel Programming | |||
| Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
| search for a specific word and copy the word and the preceeding words until a comma | Excel Programming | |||
| Macro to search a column for a specific word and replace with | Excel Programming | |||
Linear Mode
