Skip to main content

Range.PrefixCharacter property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

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



expression A variable that represents a Range object.


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.


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

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>