EXCEL VBA - Loop through range/collection

[petrcz]

Hi, I have this set of data

[TABLE="width: 500"]
<tbody>[TR]
[TD]Car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Mondeo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ford Fiesta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Honda Civic[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Toyota Prius[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]brands[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[/TR]
[TR]
[TD]Honda[/TD]
[/TR]
</tbody>[/TABLE]


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