moving table to next page

  • Thread starter Thread starter tess457
  • Start date Start date
T

tess457

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
 
hi,
in your macro, add code to find the bottom of the data
then ad
ActiveWindow.SelectedSheets.HPageBreaks.Add _
Before:=ActiveCell
ActiveWindow.SelectedSheets.VPageBreaks.Add _
Before:=ActiveCell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top