Adjust Row Height Width Excel Cells Using VBA

How to change row height and column width of Excel worksheet cells using a macro

  • Right-click on Sheet1
  • Select view code from the menu
  • In the Visual Basic editor for applications window we click on the drop-down arrow displaying ‘General’ and select ‘worksheet’
  • The ‘worksheet_Selection’ procedure is displayed. We click on the drop-down arrow next to the procedures text box and select ‘Activate’
  • View the code shown in the image below for the columns width and rows height settings
Column Width and Rows Height Settings via Excel VBA

View the training video:

Further reading:
XL2000: How to Use Macros to Set Row Height and Column Width