I don't understand why =PROPER wouldn't work!

You can copy this code to your personal.xls file and run it

Sub TextProper()
Dim ttt As String
Dim c As Object

For Each c In Selection.Cells
ttt = c.Value
c.Formula = Application.Proper(ttt)
Next
End Sub

Have a great day,
Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com



"Snowcap" wrote:

Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate cell in the spreadsheet referencing a specific cell it works. How
can I change in one worksheet all caps to PROPER ?