Edit

Font.Size property (Excel)

  • Article

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.