Hi,

I have a vbscript that needs to search in an excel sheet to find a specific word (strSearch).
Then, the script needs to know on which rownumber this word was find.
And on top, the script needs to see how many times this word was found in the specified Range. And that last one gives problems

Code:
Dim strSearch, therightrow
strSearch = InputBox("Search:") 

Set objRange = objWorksheet.UsedRange
therightrow = objRange.Find(strSearch).Row
MsgBox therightrow
With this code above, he msgboxes me the number of the row where the first match was found.

But he's not going to the next match, so I'm looking for some loop through the range in a way I get the following data:
how many rows are affected with that match
the rownumbers of these rows.

I've been trying lots of things already, like this (obviously wrong):
Code:
Do Until objRange.Find(strSearch).count <> strSearch 
Loop
Can someone help me?

I'm using it in Internet Explorer.