EXCEL VBA - Loop through range/collection

[petrcz]

Hi, I have this set of data

Car
Ford Mondeo
Ford Fiesta
Honda Civic
Toyota Prius

<tbody>
</tbody>

brands

Ford

Honda

<tbody>
</tbody>

I try to write a macro which adds brands into collection/range and then check, if there is this substring (brand) in a range.
Any hints?

Thanks a lot in advance

 

[NickRed18]

Try the FIND worksheet function