repeat rows at top and bottom of worksheet simoltaneously

[Guest]

When printing a worksheet, is it possible to repeat some rows at the top and
some other rows at the bottom of the worksheet at the same time?

 

[Roger Govier]

Hi

Not without writing some code.
The Page Setup only allows you to specify number of rows to repeat at
the top of each sheet.

 

[Guest]

Hi Roger,

Could you provide me with some more information about writing the relevant
codes?

 

[Roger Govier]

Hi

I'm sorry, I don't have time right now to write the necessary VBA code
for you, but try using the macro recorder to set something up.

If you switch on the macro Recorder, Tools>Macros>Record new macro
as you carry out the steps manually, it will record them for you.

Basically,
Set up either on another sheet, or somewhere outside your normal print
range, the footer info you want.
Insert a few lines on your Sheet.
Copy in to those inserted lines the footer information you want to
print.
Select the area (including these new lines)
Print
Delete the inserted lines
Move to the bottom of the next page you want to print
Insert lines etc.
When finished, press the square Stop button on the Macro toolbar

Next time choose Tools>Macro>Run

 

[Roger Govier]

Hi

I should have said

Set up either on another sheet, or somewhere outside your normal print
range, the footer info you want.

Then switch on the macro Recorder, Tools>Macros>Record new macro
as you carry out the following steps manually

Basically,
Insert a few lines on your Sheet.
Copy in to those inserted lines the footer information you want to
print.
Select the area (including these new lines)
Print
Delete the inserted lines
Move to the bottom of the next page you want to print
Insert lines etc.
When finished, press the square Stop button on the Macro toolbar

Next time choose Tools>Macro>Run