Consulting

Results 1 to 3 of 3

Thread: Print title + Dynamic range until empty row

  1. #1
    VBAX Newbie
    Joined
    Sep 2015
    Posts
    1
    Location

    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:


    CVDV_tab.jpg


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


    CVDV_00_AZ.jpg

    CVDV_00_AR.jpg
    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
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,240
    Location
    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
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,021
    cross posted:
    https://www.daniweb.com/programming/...ntil-empty-row
    http://www.excelforum.com/excel-prog...empty-row.html

    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 http://www.excelguru.ca/content.php?184

Posting Permissions

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