Export (0) Print
Expand All
Expand Minimize

Range.PrefixCharacter Property

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

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



Community Additions

ADD
Show:
© 2015 Microsoft