Spreadsheet.CaseName

This property returns/sets the specified case name.

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

The case index.

Type: Integer

String

SVB Example

Changing case names: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'sets the name of case 4
    spr.CaseName(4) = "Case Four Name"
    'returns the name of case 1
    MsgBox "The name of case one = " & spr.CaseName(1)
End Sub