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

1 comment:

  1. Hi there to every body, it's my first pay a quick visit of this webpage; this website
    carries amazing and truly fine information for visitors.

    ReplyDelete

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