+ Reply to Thread
Results 1 to 3 of 3

Repeat first rows in the beginning for each page print + page nr

  1. #1
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Repeat first rows in the beginning for each page print + page nr

    One worksheet only.
    First 10 rows are static including headers at row A10:AT10 and BA10:BT10. Below each range are 100 rows with different objects.
    When printing with code below, only the first page of A10:AT10 will have headers (correctly), page 2-3 don't have any headers.
    Then page 4 of BA10:BT10 (correctly) will have headers but not page 5 and 6.

    This makes it hard to see on page 2-3 and 5-6 what header each column has.

    1) Is it possible for each page to repeat the area from A2:AT10 and BA2:BT10?

    2) Also, is it possible to include some kind of page number at the bottom right or top right?

    Please Login or Register  to view this content.
    Last edited by jokris; 04-17-2016 at 06:23 PM.

  2. #2
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Repeat first rows in the beginning for each page print + page nr

    Found a solution for page number:

    With ActiveSheet.PageSetup
    .Zoom = False
    .FitToPagesWide = 1
    .FitToPagesTall = False
    .RightFooter = "&P"
    End With

  3. #3
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Re: Repeat first rows in the beginning for each page print + page nr

    Is it something like this below?
    Guess this code will print all range, but I want to separate into first pages with header range A2:AT10, then pages with header range BA2:BA10.

    Please Login or Register  to view this content.
    Last edited by jokris; 04-17-2016 at 06:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 10-16-2013, 08:39 AM
  2. [SOLVED] print bottom row repeat on every page
    By nilesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  3. [SOLVED] print bottom row repeat on every page
    By nilesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. print bottom row repeat on every page
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  5. [SOLVED] print bottom row repeat on every page
    By nilesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  6. print bottom row repeat on every page
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 05:05 AM
  7. [SOLVED] print bottom row repeat on every page
    By nilesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  8. [SOLVED] print bottom row repeat on every page
    By nilesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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