B Bob Phillips Nov 23, 2005 #2 In VBA, use Union -- HTH RP (remove nothere from the email address if mailing direct)