Results 1 to 3 of 3

Thread: Print title + Dynamic range until empty row

  1. #1
    VBAX Newbie
    Sep 2015

    Print title + Dynamic range until empty row

    Hello everybody,

    I'm doing a colleague a favor by looking into a VBA formula to make her reporting tasks a little easier, poor her, but I need help myself now.

    this is how her tabsheet is set up:


    this is how the end result should look like in the printer tray:


    some facts:

    - the values in column B ("APE", "APF", ...) are the 'seperators'. I tried to define a loop where the module selects the data until it finds an empty row, but there are 2 empty rows for each value in column B (e.g. for APE = row 7 & row 11) and it got me confused.
    - the number of rows that need to be printed on a seperate page are dynamic: e.g. for B5 = "APE", one day it's 2 persons, the other day it's more or less than 2.
    - the title in cell D2 should show on each page
    - the number of columns doesn't change

    Could use the help, thanks in advance!
    Last edited by JVAII; 09-30-2015 at 10:56 AM.

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Oct 2006
    Near Columbia
    It sure looks to me like the "Separators" are in Column A.

    Why do you need to print the note about titles on each printed page? BTW, where are the Titles that must be printed on each page?

    Is it ever possible that there will be enough entries in Columns B & C that it will require more than one printed Page?
    I expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  3. #3
    Knowledge Base Approver VBAX Wizard
    Oct 2005
    Surrey UK
    cross posted:

    before anyone sets to work on a solution, check the above (excelforum already has an offered solution).

    JVAII, you should really provide these cross post links yourself… why? See

Posting Permissions

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