Chris,
Here is some simple code
Dim cell As Range
For Each cell In Selection
cell.Value = WorksheetFunction.Proper(cell.Value)
Next cell
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"CLew " wrote in message
...
Dear all,
I have a Excel sheet with 13,000 names and address that are all in
upper case. Is there way to automate the Proper function so that the
cases are corrected? That is, the first character of the first and
last names is in upper case and rest in lower case. I'm rather new to
using macros in Excel.
Thanks in advance!
-Chris
---
Message posted from http://www.ExcelForum.com/