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

View the training video:

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