+ Reply to Thread
Results 1 to 4 of 4

Return Relative Reference Value based on Page Break

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    2007
    Posts
    63

    Return Relative Reference Value based on Page Break

    Hello Again,

    I've got the following code that creates a page break for every change in a defined column (starting after row 3 to accomodate my table header).

    I repeat the header on each page through Print Tiles. My goal would be to be able to have the Row above the repeated tiles reference the new changed value.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,492

    Re: Return Relative Reference Value based on Page Break

    The code you sent seems incomplete.
    Last edited by PCI; 05-16-2020 at 04:46 AM.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    2007
    Posts
    63

    Re: Return Relative Reference Value based on Page Break

    I am attempting another routine that forgets about using the Print Tiles Feature and just manually copying/pasting the first two rows during the page break loop but I keep getting an error that the copy/paste area isn't the same size.

    I feel like something a long these lines should work, but I can't seem to figure out the right words to use to make this happen.

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,492

    Re: Return Relative Reference Value based on Page Break

    See next code and file attached : Sheet "Original" page setup is changed.
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Move Page Break 1 cell up if bullet-point is in on the page break.
    By saudi_red_neck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2019, 10:24 AM
  2. Return relative row with R1C1 reference style
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2018, 12:22 PM
  3. Match then Return Relative Reference that Also Matches
    By rjj920 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2018, 06:50 PM
  4. Find First match value and add page break, findnext value and add page break
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 12:58 PM
  5. Heading based on page break
    By scottydogg84 in forum Excel General
    Replies: 0
    Last Post: 09-28-2011, 10:26 AM
  6. [SOLVED] Page Break based on Dates
    By Dan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2005, 04:06 PM

Tags for this Thread

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