Damsel Needs Assitance with Proper_Case Macro
Unless that is a very old article, the information isn't correct. The below
should work.
Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In
ActiveSheet.UsedRange.SpecialCells(xlConstants,xlT extValues)
if Ucase(x.Value) = x.Value then
x.Value = strconv(x,vbProperCase)
end if
Next
End Sub
to demo from the immediate window:
x = "ABCDE FGHI JKLM NOPQ"
? strconv(x,vbProperCase)
Abcde Fghi Jklm Nopq
Anyway, it worked for me.
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"SP" wrote in message
...
Hi all, Looking for some assistance here from a knight in shining amour.
I
found this macro on Microsoft's KB:
Sub Proper_Case()
' Loop to cycle through each cell in the specified range.
For Each x In Range("C1:C5")
' There is not a Proper function in Visual Basic for Applications.
' So, you must use the worksheet function in the following form:
x.Value = Application.Proper(x.Value)
Next
End Sub
I need to modify it to do the whole spreadsheet. I am VBA Phobia and have
been working with it for over 30 minutes. PLEASE HELP!!!
I just need to macro to change all cells that have uppercase to reflect
capitalizing the first letter of each word in the cell.
Thanks So Much
@-------
Sheri
|