I have a range name "Journals", which is from S12:X182 on the active sheet.
I need the code amended so that the page Breaks are at Row 60, 107, 156, and 180, but should allways be one row below "Journal Check" in Col U within the named Range should the range change
It would be appreciated if someone could assist me
I have also posted on https://www.mrexcel.com/board/thread...rnals.1235799/
Please Login or Register to view this content.
Re: Macro to set Page Breaks
Already solved in a previous thread ‼
Why adding such useless object variables ? And you forgot to release them before the procedure ends …
Anyway the obviously obvious :
- ResetAllPageBreaks codeline must be after PageSetup codelines.
- Do not confuse vertical breaks with horizontal breaks ‼
Last edited by Marc L; 04-26-2023 at 09:20 AM. Reason: typo ?
I managed to set the page breaks using this code, where the range per break is > 45 rows and where it is not in the same row as Journal Checks in Col U to extend the break to one row below this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks