Thank you, this works - sort of.....
I no longer get the error when I use the union but it does not find it
in the range 'rngFound'.
This code works if I have one range like 'BU' or 'Affl' but not both
(at least one instance exists).
Am I missing something obvious?
Thanks for all your help.
--
shternm
------------------------------------------------------------------------
shternm's Profile:
http://www.excelforum.com/member.php...nfo&userid=858
View this thread:
http://www.excelforum.com/showthread...hreadid=472191