Results 1 to 30 of 30

Insert PageBreak after each 50 Rows

Threaded View

nordicdust Insert PageBreak after each... 05-17-2019, 04:11 PM
Keebellah Re: Insert PageBreak after... 05-17-2019, 06:11 PM
nordicdust Re: Insert PageBreak after... 05-18-2019, 12:46 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 12:48 AM
nordicdust Re: Insert PageBreak after... 05-18-2019, 01:12 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 02:46 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 02:53 AM
nordicdust Re: Insert PageBreak after... 05-18-2019, 03:12 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:08 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:19 AM
nordicdust Re: Insert PageBreak after... 05-18-2019, 03:24 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:30 AM
nordicdust Re: Insert PageBreak after... 05-18-2019, 03:45 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:46 AM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:56 AM
torachan Re: Insert PageBreak after... 05-18-2019, 07:04 AM
Roel Jongman Re: Insert PageBreak after... 05-18-2019, 12:32 PM
nordicdust Re: Insert PageBreak after... 05-18-2019, 04:42 PM
Keebellah Re: Insert PageBreak after... 05-18-2019, 03:06 PM
Roel Jongman Re: Insert PageBreak after... 05-18-2019, 07:34 PM
nordicdust Re: Insert PageBreak after... 05-19-2019, 02:08 AM
Roel Jongman Re: Insert PageBreak after... 05-19-2019, 06:51 AM
nordicdust Re: Insert PageBreak after... 05-26-2019, 12:11 PM
Roel Jongman Re: Insert PageBreak after... 05-26-2019, 12:27 PM
nordicdust Re: Insert PageBreak after... 05-26-2019, 12:57 PM
nordicdust Re: Insert PageBreak after... 05-26-2019, 01:12 PM
Roel Jongman Re: Insert PageBreak after... 05-27-2019, 03:52 AM
nordicdust Re: Insert PageBreak after... 06-08-2019, 04:45 AM
Roel Jongman Re: Insert PageBreak after... 06-08-2019, 08:52 AM
nordicdust Re: Insert PageBreak after... 06-08-2019, 09:05 AM
  1. #1
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    413

    Insert PageBreak after each 50 Rows

    I am trying to insert PageBreaks with VBA.

    My sheet has multiple tables and they are with different amount of Rows.

    With the Row Hight it should be approximately a PageBreak per 50 Rows.
    The PageBreak must take in to consideration that:
    The first 15 Rows in the sheet don't change.
    All tables have 2 rows between them.
    The last 50 must be on one Page.

    I am not sure how to go about this, so any idears will be greatly apreciated :-)
    Udklip.JPG This is a picture
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] excel VBA insert pagebreak after shape
    By wambaugh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2015, 04:30 PM
  2. Inserting rows such that reference rows is after an automatic pagebreak
    By Tester80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2013, 04:16 PM
  3. [SOLVED] Insert title by pagebreak in a certain cell value
    By Danielle22 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-12-2013, 01:26 PM
  4. Replies: 1
    Last Post: 08-04-2010, 12:46 PM
  5. VBA expression to insert pagebreak
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-30-2008, 11:07 AM
  6. PageBreak and Insert the value in Header based on a cell value (Lookup)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-30-2008, 02:01 PM
  7. insert pagebreak after a specific column?
    By Macroman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-03-2006, 07:20 AM

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