done some more testing and its now clear that the carriage return tha
is in the oval is not the same as a 'vbnewline' so basically its no
picking it up, which is whats causing the error.

there must be another way to detect a return character other tha
looking for vbnewline?

thank

--
Message posted from http://www.ExcelForum.com