Macro (SVB) Programs Example - Auto-Fitting a Spreadsheet's Variable Columns

This example will iterate through all of the open, individual spreadsheets and auto-fit each variable column to the proper width.

Sub Main()

'This macro will auto fit the variable columns of
'every open, individual spreadsheet

Dim i As New Spreadsheet
'loop through every individual spreadsheet window

For Each i In Application.Spreadsheets
'loop through each variable column
'one spreadsheet at a time

For j = 1 To i.Variables.Count
'autofit each variable column, one at a time

i.Variable(j).AutoFit

Next j

Next i

End Sub