How can I find the rowheight and use it in a formula?
My spreadsheet hides certain rows depending on data input. I would
like to add up the total height of all the rows after some are hidden
to help determine if multiple pages are needed to print out the total
sheet. It is my intention to set up special formatting for printing
if the total row height exceeds a certain number.
Is there any practical way to read the row heights of several rows and
add them together - then use the total number in another formula? I
can do this with column widths, but I do not know if it can be done
with row heights.
Thanks in advance for any help.
|