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? |
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? |
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? . |
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 |
All times are GMT +1. The time now is 02:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com