Skip to main content

Range.Font property

Table of contents
  1. Syntax
  2. Example

Returns a Font object that represents the font of the specified object.



expression A variable that represents a Range object.


This example determines if the font name for cell A1 is Arial and notifies the user.

Sub CheckFont()
    ' Determine if the font name for selected cell is Arial.
    If Range("A1").Font.Name = "Arial" Then
        MsgBox "The font name for this cell is 'Arial'"
        MsgBox "The font name for this cell is not 'Arial'"
    End If
End Sub

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>