Print title + Dynamic range until empty row

[JVAII]

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!

[SamT]

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?

[p45cal]

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