excel VBA search pattern

[imagoodwon]

Is there a way to force findALL or FindNext to return values from 1st found left to right.Top row to bottom row?

I have a range A2:L100 and I need to find the first match, D4, then the next one on the same row etc; There will be multiple matches .

I want the find to operate one row at a time and from left to right; not from last to first.
Sample code welcome.
Thank you

 

[Loomah]

look at the searchorder parameter
xl help isn't much use on this but you should find something on the web

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​