Excel.Range.Font.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.Font property (Excel)	vbaxl10.chm144131	vbaxl10.chm144131	Excel.Range.Font	d9cb8667-6c71-d311-a6e5-1d30d5718050	05/10/2019	medium

Range.Font property (Excel)

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 if the font name for cell A1 is Arial and notifies the user.

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

[!includeSupport and feedback]