Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pages setting
Hi,
I have a various number of rows generated in a worksheet. So There is a various number of pagebreak in this sheet. [I notice that the text in the last cell, of the last row just befre a pagebreak is wrap to the first cell of the first row just after the pagebreak.] I would like to locate the the last row of each page, and the last cell of this row. Suppose i have two pages, i consider the last row(just before the break) of the first page: If this cell contains a carriage return, then i want to change the page setting to the next row, if the next row contains a carraige return, do the same process. Or perhaps remove this carriage return maybe works fine, but how could i do that? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting pages breaks in Excel | Excel Discussion (Misc queries) | |||
Setting scroll area for multiple pages | Excel Programming | |||
Setting zoom for all worksheet pages | Excel Programming | |||
Setting zoom for all worksheet pages | Excel Programming | |||
Setting zoom for all worksheet pages | Excel Programming |