EXCEL VBA - Loop through range/collection

petrcz

New Member
Joined
Mar 25, 2016
Messages
31
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,089,922
Messages
5,411,265
Members
403,353
Latest member
ecboy1605

This Week's Hot Topics

Top