Home Excel Powerpoint Word Outlook Error Codes

VBA Useful Codes

Welcome to the World of VBA
Home > VBAUsefulCodes

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

Enter your e-mail below and get notified on the latest blog posts.




Tags

VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts


Follow Us