Remove Indentation

Brief description:

Sets all selected cells to have no indentation

Full description:

Sets all selected cells to have no indentation. Can be useful for formatting purposes.

Indenting is available from the home tab but different amounts of indentation can make its implementation a chore. For example, if certain ranges need to be selected manually.

To use: Select range that you want to remove the indentation for and then run the macro.

Code:
Option Explicit


Sub RemoveIndentation()
    'For all selected cells, set indentation to 0

    Dim CurrCell As Range
    Dim Counter As Integer
    
    For Each CurrCell In Selection
        Counter = 0
        CurrCell.IndentLevel = 0
    Next CurrCell

End Sub