Search a range of cells for a specific word

  • Thread starter Thread starter Bishop
  • Start date Start date
B

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?
 
Actually what I was looking for is the VBA code.

Don Guillett said:
Use edit>find>find>"Disclaimer". Record a macro while doing

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


.
Click to expand...
 
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.
 
This was helpful to my problem. I have a range of cells that contain blanks or one of four different initials. I'd like to search the range, then count up how many of a specific initial appeared in the range. For example if I have VG, KA, AK AND MC as the initials in a set range, I'd like to be about to show how many of each initial appeared in that range. I'm not very good with Code, so I'd like it to be an excel formula. Is there a way to do this? help help. LOL. Thanks. Bill
 
Back
Top