repeat rows at top and bottom of worksheet simoltaneously

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M. Danesh - 12 Jan 2007 08:12 GMT

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?

Reply to this Message

Roger Govier - 12 Jan 2007 08:49 GMT

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.

Signature

Regards

Roger Govier

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

Reply to this Message

M. Danesh - 12 Jan 2007 09:22 GMT

Hi Roger,

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

> Hi
>
[quoted text clipped - 5 lines]
> > top and
> > some other rows at the bottom of the worksheet at the same time?

Reply to this Message

Roger Govier - 12 Jan 2007 09:50 GMT

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

Signature

Regards

Roger Govier

> Hi Roger,
>
[quoted text clipped - 12 lines]
>> > top and
>> > some other rows at the bottom of the worksheet at the same time?

Reply to this Message

Roger Govier - 12 Jan 2007 10:12 GMT

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

Signature

Regards

Roger Govier

> Hi
>
[quoted text clipped - 36 lines]
>>> > top and
>>> > some other rows at the bottom of the worksheet at the same time?

Reply to this Message