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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
How do I exclude a cell from a range? 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Create if partial match then copy and paste data from one cell to another 1
Search Excel and copy result into word 1
Code copies between key word is in reverse order 5

Back
Top