Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic page break
I'm working with a worksheet containing data about different companies,
usually, data of each company is input in a single row, however, some of them are input into two or three rows. (eg. row 1: company A, row 2,3: company B, etc). When I print my spreadsheet, sometimes, the data of a company will spilt into 2 pages, so i manually setup some page breaks for it. I've then wrote a vba function to sort my data. The problem is that, after I sort my data, the page break position needed to be reset. I would like to know if there is any method to use vba to setup page break automatically for my case. (I want to set page break when the data will spilt into two pages). Thanks very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic page break | Excel Discussion (Misc queries) | |||
macro and automatic page break | Excel Discussion (Misc queries) | |||
Excel-page break automatic | Excel Discussion (Misc queries) | |||
Excel: How do you insert an automatic page break after each row? | Excel Discussion (Misc queries) | |||
Cannot move an automatic page break | Excel Discussion (Misc queries) |