Edit - Outdent

Ribbon bar. Select the Macro tab. In the Tab group, click Outdent to outdent (shift to the left) the highlighted code in the macro window.

Classic menus. From the Edit menu, select Outdent to outdent (shift to the left) the highlighted code in the macro window.

Outdenting is useful for formatting blocks of code to make it more readable. Consider the following example:

This For loop is rather difficult to read:

For i = 1 To ActiveSpreadsheet.NumberOfCases
 'add all the cases to marked, remove any
 'special formatting, and adjust its height
 ActiveSpreadsheet.Case(i).AddToMarked
 ActiveSpreadsheet.Case(i).ClearFormats
 ActiveSpreadsheet.Case(i).AutoFit
 Next i

Outdenting the For and Next instructions better defines where the loop begins and ends:

For i = 1 To ActiveSpreadsheet.NumberOfCases

'add all the cases to marked, remove any
 'special formatting, and adjust its height
 ActiveSpreadsheet.Case(i).AddToMarked
 ActiveSpreadsheet.Case(i).ClearFormats
 ActiveSpreadsheet.Case(i).AutoFit

Next i

Note: outdenting will not have any effect on the execution of your macro; it is merely a cosmetic feature. See also Edit - Indent.