..Range("A3:AI5").Cells.SpecialCells(xlCellTypeCon stants)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" wrote in message ...
The situation I had in mind Ron, is where my TO; CC and BCC addresses
are all in the same column