To change text in a selected range to proper case use this code.
Sub ProperCase()
Dim cell As Range
For Each cell In Selection.Cells
If cell.HasFormula = False Then
cell = strconv(cell.text,vbProperCase)
End If
Next
End Sub
Monday, February 4, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment