Hi Don,

I think that your sub will overwrite data if the SpecialCells range
comprises more than one area.

The sub needs to loop through the SpecialCells range's constituent cells.

---
Regards,
Norman



"Don Guillett" wrote in message
...
from a post of mine on the 23rd.
if you have formulas, use this instead or you will wipe out the formulas

Sub makeproper()
With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants)
.Value = Application.Proper(.Value)
End With
End Sub


--
Don Guillett
SalesAid Software

"dumbfounded" wrote in message
...
I have a spreadsheet containing data to make mailing labels. The whole
thing
was entered in caps. I need to change it to the Proper style ( the first
letter is capitalized and the rest lower case). How can I do this?