Friday, 21 September 2012

Excel VBA Macro To Format Border Styles , Font Styles

Excel VBA Macro To Change Border Styles

Sub BorderStyles()

'Style1:Selection.Borders.LineStyle = xlContinuous
'Style2:Selection.Borders.LineStyle = xlDouble
End Sub

'Macro To Change Font Styles

Sub FontFormats()

With Selection.Font

.Name = "Arial"
.Size = 12
.Italic = True
.ColorIndex = 10
.Bold = True
.Underline = True

End With

End Sub

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts