Home > VBAUsefulCodes
Dynamically change or set the column width in Excel using ColumnWidth property of a Single or Multiple Columns in VBA.
Change Single And Multiple Columns Width in Excel using VBA
Dynamically change or set the column width in Excel using ColumnWidth property of a Single or Multiple Columns in VBA.
'Change Single Column Width
Sub Change_Single_Column_Width()
'Changing the 2nd Column Width
Columns("B").ColumnWidth = 25
End Sub
' Change Multiple columns Width
Sub Change_Multiple_Columns_Width()
'Changing Multiple Columns Width
Columns("B:E").ColumnWidth = 25
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts