I'm having trouble setting up a dynamic print range and hope someone can
point me in the right direction. I have a single page spreadsheet that is
the output of a testing program. I want to be able to automatically print
the results which will always be contained in a known # of columns but a
variable # of rows.

I have defined the print_area as:

=OFFSET(P17,0,0,MATCH(2999,O17:O175,1),13)

which works until I try to save and reopen the spreadsheet at which time
it's a fixed range. In reading through posts it appears I need to add a
Visual Basic set of commands but the ones I have tried so far don't seem to
work. Any help would be appreciated.

Mike
--
Mike B

How are you saving the workbook and what is the range after you reopen it?

Barb Reinhardt


"mikeb" wrote:

I'm having trouble setting up a dynamic print range and hope someone can
point me in the right direction. I have a single page spreadsheet that is
the output of a testing program. I want to be able to automatically print
the results which will always be contained in a known # of columns but a
variable # of rows.

I have defined the print_area as:

=OFFSET(P17,0,0,MATCH(2999,O17:O175,1),13)

which works until I try to save and reopen the spreadsheet at which time
it's a fixed range. In reading through posts it appears I need to add a
Visual Basic set of commands but the ones I have tried so far don't seem to
work. Any help would be appreciated.

Mike
--
Mike B

Are you sure you didn't go into File|Page setup (or whatever it is in xl2007).

If you did, you may have messed up your print_area (losing the dynamic part).

mikeb wrote:

I'm having trouble setting up a dynamic print range and hope someone can
point me in the right direction. I have a single page spreadsheet that is
the output of a testing program. I want to be able to automatically print
the results which will always be contained in a known # of columns but a
variable # of rows.

I have defined the print_area as:

=OFFSET(P17,0,0,MATCH(2999,O17:O175,1),13)

which works until I try to save and reopen the spreadsheet at which time
it's a fixed range. In reading through posts it appears I need to add a
Visual Basic set of commands but the ones I have tried so far don't seem to
work. Any help would be appreciated.

Mike
--
Mike B

--

Dave Peterson