Search a range in a specific order

[imagoodwon]

I thought I had posted this before, but I didn't see it showing up.
I want to find the first instance of a search result starting top left, and then progressing right through that row, then starting agin on the next row top left to right etc..etc..
How can I code this using vba to find multiple occourances of the results.

I want to TAG the first found result ( The leftmost ) and copy it to another page so that I can shade it red. the other results will go to the right of it on the same row if they were on that row.

My search says if Column Z.value >0 then find all matches of TextBox1.value on that row, then, go to the next row and do the same until the end of the search range. A2100

 

[xlhelp]

You should post this in:
forum707

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[SkipVought]

In addition to posting your question inf Forum707, please advise what Version of Excel

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]