Skip to main content

Range.Characters property

Returns a Characters object that represents a range of characters within the object text. Use the Characters object to format characters within a text string.

Syntax

expression.Characters (Start, Length)

expression A variable that represents a Range object.

Parameters

Name Required/Optional Data type Description
Start Optional Variant The first character to be returned. If this argument is either 1 or omitted, this property returns a range of characters starting with the first character.
Length Optional Variant The number of characters to be returned. If this argument is omitted, this property returns the remainder of the string (everything after the Start character).

Remarks

The Characters object isn't a collection.

Example

This example formats the third character in cell A1 on Sheet1 as bold.

With Worksheets("Sheet1").Range("A1")
    .Value = "abcdefg"
    .Characters(3, 1).Font.Bold = True
End With

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>