if you read the two columns into an array each. The arrays should be two
dimensional so that you can store both the value and the address.

Then loop through the shortest array and for each element search the
second array for the same value. If a match is found :
- colour the cells (you have the addresse in the second element)
- and either remove the element from the second array (or set the
values to an impossible value)
- goto the next item in the first array


Improvements could be made be either sorting the columns first or by
using a collection so that the numbers are held in sorted order.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=514323