I trying to develop a macro to print my worksheets. Here's the problem, I never know how much data my end-users will incorporate into any one worksheet. In some instances, one worksheet can result in five pages or more of printout.
How do I acheive the following:
1.) set a page break so that if, for example, I have 400 rows or 4000 rows of data that each page print 40 rows data.
2.) print multiple row column headings on each page.
Iwould appreciate any help on the subject.