Class Characters (Excel VBA)

The class Characters represents characters in an object that contains text.


Returns a String value that represents the text of this range of characters.


Returns a Long value that represents the number of objects in the collection.

Sub MakeSuperscript() 
 Dim n As Integer 
 n = Worksheets("Sheet1").Range("A1").Characters.Count 
 Worksheets("Sheet1").Range("A1").Characters(n, 1) _ 
 .Font.Superscript = True 
End Sub


Deletes the object.


Returns a Font object that represents the font of the specified object.


Inserts a string preceding the selected characters.

Syntax : expression.Insert (String)

String: The string to insert.


Returns the parent object for the specified object. Read-only.


Returns or sets the phonetic text in the specified Characters object.

Instead of using this property, you should use the Add method of the Phonetics collection to add phonetic information to a cell, and use the Text property of the Phonetic object to return or set the phonetic text strings in a cell.

ActiveCell.Characters(1,3).PhoneticCharacters = "フリガナ"


Returns or sets the text for the specified object.