| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search text & record number of times it appears
Here's a shorter version
Sub CountCells() Dim findText as String, found as Long findText = "dog" Found = application.Countif(worksheets(1).Range("A1:Z26"), _ "*" & findText & "*") MsgBox "Found " & Found & " instances of " & findText End sub -- Regards, Tom Ogilvy wrote in message oups.com... That was quick. Worked like a charm. Thanks a million regards, Julian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number times text appears in string | Excel Discussion (Misc queries) | |||
| Count the number of times specific text appears in a column | Excel Worksheet Functions | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| count number of times text appears | Excel Discussion (Misc queries) | |||
| How do I count the number of times a value appears? | Excel Worksheet Functions | |||
Hybrid Mode
