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