Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Cleans up every selected cell
Sub FixTextInAllCells()
         Dim Cell
         For Each Cell In Selection
             Cell.Value = Application.WorksheetFunction.Proper(Cell.Value)
         Next
     End Sub