Sets all selected cells to have no indentation
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.
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