Excel.Range.PrefixCharacter.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.PrefixCharacter property (Excel)	vbaxl10.chm144179	vbaxl10.chm144179	Excel.Range.PrefixCharacter	1f7d5fbc-136a-5164-4cec-0054f8bcd0b1	05/11/2019	medium

Range.PrefixCharacter property (Excel)

Returns the prefix character for the cell. Read-only Variant.

Syntax

expression.PrefixCharacter

expression A variable that represents a Range object.

Remarks

If the TransitionNavigKeys property is False, this prefix character will be ' for a text label, or blank.

If the TransitionNavigKeys property is True, this character will be ' for a left-justified label, " for a right-justified label, ^ for a centered label, \ for a repeated label, or blank.

Example

This example displays the prefix character for cell A1 on Sheet1.

MsgBox "The prefix character is " & _ 
 Worksheets("Sheet1").Range("A1").PrefixCharacter

[!includeSupport and feedback]