Thanks Tom. Doesn't appear to work though as I get an error statin
some of the cells contain more than 255 characters, which stops th
macro in its tracks. Is there a workaround or another option

--
Sandema
-----------------------------------------------------------------------
Sandeman's Profile: http://www.excelforum.com/member.php...fo&userid=3244
View this thread: http://www.excelforum.com/showthread.php?threadid=52922