still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
Hi
I use this macro in a spreedsheet to change what is typed in C:C to proper case
I got a lot of help for writing the macro from this site…Thank you
I would like to modify it for another worksheet.
I would like to have every other column change to proper case
B4:B40,D4:D40,F4:F40 all the way to X4:X40
The columns in between are numbers
mike
I use this macro in a spreedsheet to change what is typed in C:C to proper case
I got a lot of help for writing the macro from this site…Thank you
I would like to modify it for another worksheet.
I would like to have every other column change to proper case
B4:B40,D4:D40,F4:F40 all the way to X4:X40
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
Application.EnableEvents = False
Target.Value = WorksheetFunction.Substitute(WorksheetFunction.Proper(WorksheetFunction.Substitute(Target, "'", "z-z")), "z-Z", "'")
Application.EnableEvents = True
End If
End Sub
mike