info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Format Sheet
2 views
Skip to first unread message
Peter Sowerby
Feb 7, 1999, 3:00:00 AM2/7/99
to
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.
the sheet so I get the cell into PROPER format.
Peter.
Thomas Ogilvy
Feb 7, 1999, 3:00:00 AM2/7/99
to
Peter,
here is a macro which you can run on the sheet:
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
Feb 7, 1999, 3:00:00 AM2/7/99
to
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.
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
0 new messages