Excel.Characters.Count.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Characters.Count property (Excel)	vbaxl10.chm252074	vbaxl10.chm252074	Excel.Characters.Count	0fabbbe3-5c4a-c215-1bc0-201ee5971fb0	04/16/2019	medium

Characters.Count property (Excel)

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

Syntax

expression.Count

expression A variable that represents a Characters object.

Example

This example makes the last character in cell A1 a superscript character.

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

[!includeSupport and feedback]