Share via


Phonetics.Length Property (Excel)

Returns a Long value that represents the number of characters of phonetic text from the position you've specified with the Start property.

Syntax

expression .Length

expression A variable that represents a Phonetics object.

Example

This example returns the length of the second phonetic text string in the active cell.

ActiveCell.FormulaR1C1 = "東京都渋谷区代々木" 
ActiveCell.Phonetics.Add Start:=1, Length:=3, Text:="トウキョウト" 
ActiveCell.Phonetics.Add Start:=4, Length:=3, Text:="シブヤク" 
MsgBox ActiveCell.Phonetics(2).Length

See Also

Concepts

Phonetics Object

Phonetics Object Members