Hi Tim,

Am Tue, 22 Jul 2014 19:16:37 +0100 schrieb TimR1316:

Maybe there's something else causing the downstream problem, but this
seems to happen frequently when dealing with text like this. I can
normally fix it manually, but there are so many cells like this, it
would take me forever to fix them.

try:

Sub Test()
Application.ScreenUpdating = False
ActiveSheet.UsedRange.WrapText = False
Application.ScreenUpdating = True
End Sub


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional