Change the Row Height and Column Width

    To change the Row Height here i used:

  • Rows Function
  • Range Object

    •  

     

    To change the Column Width here i used:

  • Columns Function
  • Range Object

    • Download The Workbook

     

    Sub Change_RowHeight_And_ColumnWidth()
    'Increse Row Height - Rows function
    Rows(5).RowHeight = 35
    Rows("8:11").RowHeight = 25

    'Change the row height by using RowHeight Property of Range Object
    Range("A5").RowHeight = 15
    Range("A8:A11").RowHeight = 15

    'Change the column width -- Columns function
    Columns("B").ColumnWidth = 11
    Columns("C:E").ColumnWidth = 11

    'Change the column width by using ColumnWidth Property of Range Object
    Range("B1").ColumnWidth = 8.43
    Range("C1:E1").ColumnWidth = 8.43

    End Sub

     

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli