Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Damsel Needs Assitance with Proper_Case Macro
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula assitance needed | Excel Worksheet Functions | |||
Assitance W/ An If/Then formula | Excel Discussion (Misc queries) | |||
Damsel in distress needs VBA help!!! | Excel Discussion (Misc queries) | |||
.GetOpenFilename assitance | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |