repeat rows at top and bottom of worksheet simoltaneously

M

M. Danesh

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?
 
R

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.
 
M

M. Danesh

Hi Roger,

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

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top