PS:
my solutions are supposed to be used for sheets that contain data that
should not be printed. eg. you have some headlines in rows 1 to 5 and
some columns starting with H that must be in the sheet but should not
be printed. so, you need to print from A6 to G???? depending on how
many records you have.

define the printarea with the following formula, if the number of
records plus report-headlines is in range "recnr":
=offset($A$6, 0, 0, recnr, 7)

arno