moving table to next page
 

i have a little dilemma that i cannot seem to solve, I have searched th
databases without any luck. Every time the user selects to print, i ru
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 o
that page, part of it goes on to the next page, is there a easy way o
having the whole table print of the next page, instead of printing som
of the table on one page, and some on the next...thank

--
tess45
-----------------------------------------------------------------------
tess457's Profile: http://www.excelforum.com/member.php...fo&userid=1393
View this thread: http://www.excelforum.com/showthread.php?threadid=26619

moving table to next page
 

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

.