Advertisement
ROODAY

Clean Sheet

Jul 27th, 2016
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub CleanSheet()
  2.     Dim r As Range
  3.     Application.ScreenUpdating = False
  4.     For Each r In Range(Cells(1, 1), Cells(252441, 75))
  5.         If TypeName(r.Value) = "String" Then
  6.             r = WorksheetFunction.Clean(r)
  7.         End If
  8.     Next r
  9.     Application.ScreenUpdating = True
  10. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement