Skip to main content

Font.Size property

Table of contents
  1. Syntax
  2. Example

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>