Mervyn Thomas;593677 Wrote:
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?

Code:
--------------------
For each cll in selection.cells
cll.value = lcase(cll.value)' either this line or the next
'cll.Value = Application.WorksheetFunction.Proper(cll.Value)
next cll
--------------------


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=164484

Microsoft Office Help