Search a range of cells for a specific word

[Bishop]

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?

 

[Don Guillett]

Use edit>find>find>"Disclaimer". Record a macro while doing

 

[Bishop]

Actually what I was looking for is the VBA code.

Use edit>find>find>"Disclaimer". Record a macro while doing

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)


.

 

[Dave Peterson]

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.