just a quick question (with probably a simple answer)
i want to change an entire worksheet to proper case (which is done with the code you posted, but i also have some columns that will have formulas in them. when you change a worksheet to proper, if you dont omit cells that have formulas in them they will change to text (or numbers), but i need to keep the formula intact. any help would be greatly appreciated.
thanks. jake

Quote Originally Posted by stephenloky View Post 
Sub proper()
    Dim rng As Range, cell As Range
    Set rng = ActiveSheet.UsedRange
    For Each cell In rng.Cells
        cell.Value = WorksheetFunction.proper(cell.Value)
    Next
End Sub
That should do the work!