Excel - Increse columns in range by 5
Posted on 2016-11-21
I need VBA to increase all COLUMNS in a selected range by +3
I tried taking the sub for increasing rows, which works, and changed it to columns, but it does not work. It increases ALL columns in the sheet not the desired columns.
Here is what I tried...................
Dim column As Range
For Each column In Range("A:A,B:B,C:C,D:D,E:E,F:F,G:G,H:H,O:O,R:R,U:U").Columns
Columns.ColumnWidth = column.ColumnWidth + 5
Thanks so much