Format Sheet

[Peter Sowerby]

People at work keep typing in Captial Letters, is there a way I can format
the sheet so I get the cell into PROPER format.

Peter.

[Thomas Ogilvy]

Peter,
here is a macro which you can run on the sheet:

Sub MakeProper()
Set rng1 = ActiveSheet.UsedRange.SpecialCells(xlConstants, xlTextValues)
For Each cell In rng1
cell.Value = Application.Proper(cell.Value)
Next cell
End Sub

Regards,
Tom Ogilvy

Peter Sowerby wrote in message ...

[DMcRitchie]

Hi Peter,
You can by using PROPER in a VBA macro. See my page
http://members.aol.com/rexx03/excel/proper.htm
Check out the Related areas if you want to include cells with formulas or want
to know how to install/use a macro.

HTH, David McRitchie
My Excel Pages: http://members.aol.com/dmcritchie/excel/excel.htm