repeat rows at top and bottom of worksheet simoltaneously

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?

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.

--
Regards

Roger Govier


"M. Danesh" M. wrote in message
...
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?

Hi Roger,

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

"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"M. Danesh" M. wrote in message
...
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?

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, ToolsMacrosRecord 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 ToolsMacroRun

--
Regards

Roger Govier


"M. Danesh" wrote in message
...
Hi Roger,

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

"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"M. Danesh" M. wrote in message
...
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?

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, ToolsMacrosRecord 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 ToolsMacroRun

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
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, ToolsMacrosRecord 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 ToolsMacroRun

--
Regards

Roger Govier


"M. Danesh" wrote in message
...
Hi Roger,

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

"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"M. Danesh" M. wrote in message
...
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?

Thank you very much.

"Roger Govier" wrote:

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, ToolsMacrosRecord 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 ToolsMacroRun

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
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, ToolsMacrosRecord 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 ToolsMacroRun

--
Regards

Roger Govier


"M. Danesh" wrote in message
...
Hi Roger,

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

"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"M. Danesh" M. wrote in message
...
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?