ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multiple pages (https://www.excelbanter.com/excel-programming/394139-multiple-pages.html)

Curt

multiple pages
 
Have a column (M) that is shrink to fit When printing it is changed to word
wrap.
Would like to be able to insert row (!) into print out at beginning of any
new page.
Do not know how many lines will be in column(M) as it is different for each
line. Looked around and don't seem to locate much on this idea.
Thanks to anyone who can help
Thanks to All

barnabel

multiple pages
 
Sounds like Page Setup, Sheet Tab, Rows to repeat at top

"Curt" wrote:

Have a column (M) that is shrink to fit When printing it is changed to word
wrap.
Would like to be able to insert row (!) into print out at beginning of any
new page.
Do not know how many lines will be in column(M) as it is different for each
line. Looked around and don't seem to locate much on this idea.
Thanks to anyone who can help
Thanks to All


Curt

multiple pages
 
havent tried that will expermint I am doing this in vbe in a macro I guess
where i blank out is how to determine when to insert row not knowin how many
rows will be on a page due to size of column (M)
thanks for the direction

"barnabel" wrote:

Sounds like Page Setup, Sheet Tab, Rows to repeat at top

"Curt" wrote:

Have a column (M) that is shrink to fit When printing it is changed to word
wrap.
Would like to be able to insert row (!) into print out at beginning of any
new page.
Do not know how many lines will be in column(M) as it is different for each
line. Looked around and don't seem to locate much on this idea.
Thanks to anyone who can help
Thanks to All


Curt

multiple pages
 
tried requires contonous columns will not skip to (M)

"barnabel" wrote:

Sounds like Page Setup, Sheet Tab, Rows to repeat at top

"Curt" wrote:

Have a column (M) that is shrink to fit When printing it is changed to word
wrap.
Would like to be able to insert row (!) into print out at beginning of any
new page.
Do not know how many lines will be in column(M) as it is different for each
line. Looked around and don't seem to locate much on this idea.
Thanks to anyone who can help
Thanks to All



All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com