Range.Font Property

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

Visual Basic for Applications
`Sub CheckFont() Range("A1").Select ' 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'" Else MsgBox "The font name for this cell is not 'Arial'" End If End Sub`

Sub CheckFont() Range("A1").Select ' 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'" Else MsgBox "The font name for this cell is not 'Arial'" End If End Sub

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

See also: