ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,232
- Office Version
- 2007
- Platform
- Windows
Evening all,
I need a simple code for a one off use.
I wish to check & change all text "some also have numbers" that is in column I
My goal is to make all entries UPPER CASE & this code will be put on a macro button
Range is I8:I866
Here is my recorded macro
Thanks
I need a simple code for a one off use.
I wish to check & change all text "some also have numbers" that is in column I
My goal is to make all entries UPPER CASE & this code will be put on a macro button
Range is I8:I866
Here is my recorded macro
Thanks
Code:
Range ("I8:i866") With Selection.Font
.Name = "Calibri"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontMinor
End With
Range("I8").Select
End Sub