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.

Visual Basic for Applications
ActiveCell.FormulaR1C1 = " toukyouto toukyouto toukyouto shibuyaku shibuyaku shibuyaku yoyogi yoyogi yoyogi" ActiveCell.Phonetics.Add Start:=1, Length:=3, Text:=" toukyouto  toukyouto toukyouto  toukyouto toukyouto toukyouto" ActiveCell.Phonetics.Add Start:=4, Length:=3, Text:=" shibuyaku  shibuyaku shibuyaku" MsgBox ActiveCell.Phonetics(2).Length

See also: