Spreadsheet.CaseWeight

This property returns the case weight of the spreadsheet.

This property is read only.

Syntax Parameters Return Value
- - CaseWeight

SVB Example

Enabling case weighting: 

Option Base 1
Option Explicit
Sub Main
    Dim spr As Spreadsheet
    'assigns the active spreadsheet to the object spr
    Set spr = ActiveSpreadsheet
    'set the first variable to be the weight variable
    spr.CaseWeight.Variable = 1
    'turn on the case weight
    spr.CaseWeight.Enabled = True
End Sub