top of page

Getting Row Heights with Excel 4.0 Macro Functions

Before Visual Basic was developed, Excel used Excel 4 macro functions. These marcos still work in Excel today. They are kind of like the secret slang of Excel, and quite fun to use. Here's a simple example of the GET.CELL macro, which can use to get a list of row heights. It can be helpful when you're proofing a worksheet and want to find rows which are at the maximum row height of 409.5. Excel 4 macros will not work if you simply enter them in a cell. It's necessary to give them defined names. Follow these steps:

1. Select cell A1 and press CTRL + F3. Click New in the Name Manager.

2. Click the 'New' button. Give it the name "RowHeight".

3. in the Refers to box enter, "=Get.Cell(17,A1)". The Get.Cell macro can be used for several purposes. Refer to Phil Tracey's Excel 4.0 Macro Functions Reference posted here. Changing the number from 17 to 7 will tell you the number format of the cell reference; to 8 the horizontal alignment; 18 the name of the font, and so on.

4. In a new cell enter =RowHeight.

5. The Excel 4 macro will give the height of the row.

6. You can pull down the macro to give the height of the below rows. Note the number returned by the macro equals the number given when you select a row and choose 'Row height . . .'.

bottom of page