I am wondering if I can this
search a row and return a numeric representation of cells in that row that
start with the letters "www"
Thanks in advance

Signature
Neall
JW - 18 Sep 2007 17:36 GMT
You can use a CountIf formul for that. This will count all cells
within row 11 that starts with "www".
=COUNTIF(11:11,"www*")
If you want to do a column, then:
=COUNTIF(A:A,"www*")
> I am wondering if I can this
>
[quoted text clipped - 4 lines]
> --
> Neall
Mike H - 18 Sep 2007 17:38 GMT
Hi,
Right click the sheet tab, view code and paste this in.
Select the row you want to search and run this:-
Sub sonic()
Dim myRange As Range
Set myRange = Selection
For Each c In myRange
If UCase(Left(c.Value, 3)) = "WWW" Then Count = Count + 1
Next
MsgBox Count
End Sub
Mike
> I am wondering if I can this
>
> search a row and return a numeric representation of cells in that row that
> start with the letters "www"
>
> Thanks in advance