Range.Font Property

  • Article
Excel Developer Reference

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

Syntax

expression.Font

expression   A variable that represents a Range object.

Example

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

Visual Basic for Applications 
  Sub CheckFont()

Range("A1").Select

' Determine if the font name for selected cell is Arial.
If Range("A1").<strong>Font</strong>.Name = "Arial" Then
    MsgBox "The font name for this cell is 'Arial'"
Else
    MsgBox "The font name for this cell is not 'Arial'"
End If



End Sub

See Also