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

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts