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 . . .'.


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page