Font.Size Property

  • Article
Excel Developer Reference

Returns or sets the size of the font. Read/write Variant.

Syntax

expression.Size

expression   A variable that represents a Font object.

Example

This example sets the font size for cells A1:D10 on Sheet1 to 12 points.

Visual Basic for Applications 
  With Worksheets("Sheet1").Range("A1:D10")
    .Value = "Test"
    .Font.Size = 12
End With

See Also