Cleans up every selected cell: with Proper function : Excel Buildin Function « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel Buildin Function

Cleans up every selected cell: with Proper function

 
     Sub FixTextInAllCells()
         Dim Cell
         For Each Cell In Selection
             Cell.Value = Application.WorksheetFunction.Proper(Cell.Value)
         Next
     End Sub








Related examples in the same category

1.Use function from Excel
2.Payment Function:Pmt (interest, term, principal, future value, type)
3.Using Excel Application Functions in VBA
4.Calculate a moving average
5.Sum a Range
6.Call worksheet function directly