1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| Sub Macro3()
'
' Macro3 Macro
'
'
Range("C944").Select
ActiveCell.FormulaR1C1 = "AA01"
With ActiveCell.Characters(Start:=1, Length:=18).Font
.Name = "Calibri"
.FontStyle = "Normal"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 5
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Range("C945").Select
ActiveCell.FormulaR1C1 = "BB02"
With ActiveCell.Characters(Start:=1, Length:=15).Font
.Name = "Calibri"
.FontStyle = "Normal"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 5
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Range("C946").Select
End Sub |
Partager