Sub Macro1() Application.ScreenUpdating = False Dim MyRng As Range ForEach MyRng In Sheet1.UsedRange MyRng = Trim(MyRng) Next Application.ScreenUpdating = True EndSub
Sub Macro1() Application.ScreenUpdating = False Dim MyRng As Range ForEach MyRng In Sheet1.UsedRange MyRng = Trim(MyRng) Next Application.ScreenUpdating = True EndSub
Sub Macro1() Application.ScreenUpdating = False Dim MyRng As Range For Each MyRng In Sheet1.UsedRange MyRng = Trim(MyRng) Next Application.ScreenUpdating = True End Sub