I am using a VBA to auto fit the widest entry for a range of columns. I am wondering if there is a way to add some space to the auto fit so the columns are not so tight to the text. If some one could lay out the format I would appreciate it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA to autofit columns with added space
welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,395
- Office Version
- 2019
- 2007
- Platform
- Windows
Code:
For i = 8 to 24 ' To ActiveSheet.UsedRange.Columns.Count
Columns(i).ColumnWidth = Columns(i).ColumnWidth + 3
Next i
Upvote
0
Excel Facts
Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Similar threads
- Question
