Range.Characters Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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).

The Characters object isn't a collection.

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

Concepts

Other resources

Show: