Font.Size property (Excel)
Returns or sets the size of the font. Read/write Variant.
expression A variable that represents a Font object.
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.