Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Range.Font Property

Office 2007
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").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



Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.