Spreadsheet.VariableType

This property returns/sets the variable type of the specified variable as an integer.

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

The variable index.

Type: Integer

VariableType

SVB Example

Changing a variables type: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'change variable 2 to byte if its type is integer
    If spr.VariableType(2) = scInteger Then
        spr.VariableType(2) = scByte
    End If
End Sub