Home > VBAUsefulCodes
Dynamically change or set the Rows height in Excel using RowHeight property of a Single or Multiple Rows in VBA.
Change Single And Multiple Rows Height in Excel Using VBA
Dynamically change or set the Rows height in Excel using RowHeight property of a Single or Multiple Rows in VBA.
'Change Single Row Height
Sub Change_Single_Row_Height()
'Changing the 3rd row Height
Rows(3).RowHeight = 125
End Sub
' Change Multiple Rows Height
Sub Change_Multiple_Rows_Height()
'Changing the 3rd-25the row Height
Rows("3:25").RowHeight = 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