timamartin
asked on
Excel row height (Conditional formatting?)
I have a spreadsheet where every other row is a different height and I would like to know if there is a way to set it up so I don't have to set each row individually. There are only two row heights, 12.75 and 4 and they alternate.
snap01001.jpg
snap01001.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you press Alt+f11 to open the VBEditor, then choose Insert-Module from the menu and paste that code into the window that appears. You can then run the macro in Excel by pressing f8 and selecting it from the dialog, assuming your macro security is not set to high in the Trust Center (under Excel Options).
One small correction in rory comment, to run the macro you need to press alt+f8 on your which will open the macro window, showing the macro which you just inserted, Just select the same and hit run which will run the macro and do what you are looking for.
ASKER