Font.Size property (Excel)

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 

See also