You can set "rows to repeat at top" to be $1:$10. Your header could be "Monthly Sales Report" which prints on every page. The header would then be text that doesn't change, that you can set manually in Page setup. Read Walkenbach if you want to excel in Excel.)įor what you want it's to have one of the "rows to repeat at top" contain the thing you want to show as I'll describe.
(Of course, Walkenbach books are IMO the best even gurus buy them and read cover to cover.
If you do want to explore the Change event, is a great reference. I was thinking about some cell actually changing in column C, which obviously wouldn't happen amidst printing. I also misunderstood what you meant by "change." My fault. 5 inch from the top, and the currently printing worksheet's rows 1 to 10 or 3 to 5 or whatever prints starting 1 inch from the top. Note the margins setting screen in page setup if you have 1 inch as the top margin, and 0.5 for header, then the header starts printing. The header is something you either build in VBA or set in Page Setup. Okay, there's a difference between a "header" and "rows to repeat at top." The latter indicates the number of rows of actual cells to show atop each print page, BENEATH the header. Gurus / advanced users: I'm stuck on this, if someone doesn't mind reading this long post which possibly lays the groundwork and maybe comes close to solving the OP wish.
0 kommentar(er)
