Spreadsheet.VariableLongName

This property returns/sets the long name of the specified variable as a string.

Syntax Parameters Return Value 
Property Spreadsheet.VariableLongName( _
    VarNo As Integer) As String
VarNo [in]

The variable index.

Type: Integer

String

SVB Example

Adding a formula: 

Option Base 1
Option Explicit
Sub Main
    'Set variable 1 to be variable 2's value (formatted into currency).
    'Note that we call ConvertLocale to ensure that the formula will be
    'formatted properly under the current locale.
    ActiveSpreadsheet.VariableLongName(1) = Application.ConvertLocale("=ToStringEx(v2,""$0.00"")", scToInternational)
    ActiveSpreadsheet.Recalculate(1,,)
End Sub