Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. Dim rng As Range, cell As Range
  2.  
  3. Set rng = Selection
  4.  
  5. For Each cell In rng
  6.  
  7. Next cell
  8.  
  9. If Not cell.HasFormula Then
  10.  
  11. End If
  12.  
  13. cell.Value = WorksheetFunction.Proper(cell.Value)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement