| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert page breaks every 50 rows but do not include hidden rows
Hi there,
Is there a method to put page breaks in the used range every 50 rows but exclude any hidden rows in the count of rows. Example: a sheet with 200 rows of data and row 25 to 39 and 50 to 74 are hidden. The first page break should then appear at row 90 and the second one at row 140 etc. Any help much appreciated. -- Regards, Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: how to insert page breaks between all the rows at once? | Excel Discussion (Misc queries) | |||
| Ignore page breaks for hidden rows | Excel Discussion (Misc queries) | |||
| How do I get rid of auto pg breaks in doc with hidden rows in Exce | Excel Discussion (Misc queries) | |||
| Creating a counter that does not include hidden rows | Excel Discussion (Misc queries) | |||
| Copy Rows and insert these rows before a page break | Excel Programming | |||
![Martin[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
