VBA - Compare values in one range to another range

[Ron512]

I need some help getting started with a macro to compare values in one range to another range.

Range1 is the baseline so if Range2 has a value that is not in the Range1 it is highlighted, If Range2 does not have a value that is in Range1 that value is copied from Range1 to another column. The values do not line up with each other by row so each value in Range1 must be compared to each value in Range2. Both ranges are single columns and the values are strings.

Thanks

Ron

 

[Pretty1996]

also what does "Nothing" actually mean in this line?

RngList.Add Rng.Value, Nothing

regards
thanks

Sukh

 

[HalfAce]

A dictionary stores {Key,Item} pairs. (We're not allowed to omit the Item.)

By not specifying the key, it is by default assigning its own key to the item being added.

In the code posted earlier, Nothing (the default state of an uninitialized object variable) is used as the Item. It could alternatively be a null string ("" or vbNullString) or 0, or anything else that doesn't take up a lot of space.
so... while it's not being givin an Item by name, it is being addressed.


(Does that help answer both questions?)

 

[Pretty1996]

Thanks for the explanation mate, really appreciate it.

regards
Sukh