piers_morgan
New Member
- Joined
- Sep 3, 2003
- Messages
- 20
Is it possible to return the height of a row as a number inside a cell?
So imagine someone randomly changing the heights of 10 rows and then pressing a button. And that button initiates a macro that will impute the rowheight in cells A1:A10. So if each row was randomly a completely different height to another, there will be 10 unique values in cells A1:A10.
The reason?
The reason for this is because the project I am working on can see end users randomly changing and adding stuff to tables that eventually need to be PDF'd into reports, but with very well controlled formatting / page truncation handling (knowing row heights means another macro knows where to 'cut' a table and place onto the next page).
Thanks everyone!
So imagine someone randomly changing the heights of 10 rows and then pressing a button. And that button initiates a macro that will impute the rowheight in cells A1:A10. So if each row was randomly a completely different height to another, there will be 10 unique values in cells A1:A10.
The reason?
The reason for this is because the project I am working on can see end users randomly changing and adding stuff to tables that eventually need to be PDF'd into reports, but with very well controlled formatting / page truncation handling (knowing row heights means another macro knows where to 'cut' a table and place onto the next page).
Thanks everyone!
