PDA

View Full Version : Print tables with variable height and same heading



jiura
05-02-2008, 10:57 AM
Hello to all! I have 12 tables witch copyed from another file. Height of this tables is variable i.e. table consists of some elements, and them may be 1 and may be 10 or 100 e.t.c. All tables are on one sheet and I want to make correct print marking: Every table must begin from new page (that I have done), and also I had a problem: As table consists of many elements that may be page breaks inside table. But when such page brake take place I need a table name and a heading on this page. How can I knew where it (page break) takes place and add title on this page and then check again if this page have new page breaks? Any Ideas?

P.S. Strip rows doesn't work in this case, becouse I also need a table title witch is different from one table to other.

akanchu
05-04-2008, 06:11 PM
Just to confirm that you want to have some section of a sheet on each page that you print.
Did you try using PrintTitleRows property.
check the VBA help to see an example.
Hope this helps.