+ Reply to Thread
Results 1 to 3 of 3

Set Page Breaks automotically based in criteria

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    888

    Set Page Breaks automotically based in criteria

    I have a macro to preview the range before printing and to set page breaks


    When in Page preview, I have to manually set the page break lines and the macro is not setting them correctly

    I would like the page breaks to appear as follows:


    1) Where Other appears in Col H, page break to be below this
    2) Where Amount PAYABLE/(Refund) is in Col E page break to be below this


    It would be appreciated if someone could assist me

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Howardc1001; 05-22-2020 at 11:33 PM.

  2. #2
    Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016
    Posts
    531

    Re: Set Page Breaks automotically based in criteria

    Hi Howard,
    you can do something like this, but the problem is that the automatic pagebreaks (which cannot be removed) are set before the manual pagebreak, simply because the printable range is bigger than you want to print within the manual breaks. It's better to delete some of the blank lines.
    Please Login or Register  to view this content.
    Cheers
    Erwin
    How to learn VBA: RECORD A MACRO ... and study it.
    Still developing....

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2016
    Posts
    888

    Re: Set Page Breaks automotically based in criteria

    Thanks for the help, Erwin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1