hi,
in your macro, add code to find the bottom of the data
then ad
ActiveWindow.SelectedSheets.HPageBreaks.Add _
Befo=ActiveCell
ActiveWindow.SelectedSheets.VPageBreaks.Add _
Befo=ActiveCell

-----Original Message-----

i have a little dilemma that i cannot seem to solve, I
have searched the
databases without any luck. Every time the user selects
to print, i run
a macro which inserts a table at the bottom of the page,
my problem is,
sometimes when the table is inserted, and there is not
enought room on
that page, part of it goes on to the next page, is there
a easy way of
having the whole table print of the next page, instead of
printing some
of the table on one page, and some on the next...thanks


--
tess457
----------------------------------------------------------
--------------
tess457's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13938
View this thread:
http://www.excelforum.com/showthread...hreadid=266199

.