Increases font size of the selected cells : Selection Format « Excel « VBA / Excel / Access / Word






Increases font size of the selected cells

 

Sub IncreaseFontSize_Standard()
  Dim rng As Range, ar As Range
  If Selection Is Nothing Then Exit Sub
  For Each ar In Selection.Areas
    For Each rng In ar
      rng.Font.Size = rng.Font.Size + 2
    Next rng
  Next ar
End Sub

 








Related examples in the same category

1.Toggles between normal, bold, italic and bold+italic