Ben_goldfinch
New Member
- Joined
- Nov 15, 2016
- Messages
- 11
Im after some code to unhide rows in a range until a certain named row is at the bottom of the page
i have named the bottom row "pageendrow"
and i have hidden 20 rows named the first one "evenrowstart" and the last of the 20 rows "evenrowend"
i was think some sort of loop from 1 to 20 testing for the page break each time it returns a negative result it unhides a row and was wanting those rows to be a row height of 25.5 if that makes sense or the other option would be to have just 1 row whos's row height gets increased until the pageendrow hits the pagebreak
or open to other ideas
i have named the bottom row "pageendrow"
and i have hidden 20 rows named the first one "evenrowstart" and the last of the 20 rows "evenrowend"
i was think some sort of loop from 1 to 20 testing for the page break each time it returns a negative result it unhides a row and was wanting those rows to be a row height of 25.5 if that makes sense or the other option would be to have just 1 row whos's row height gets increased until the pageendrow hits the pagebreak
or open to other ideas