Print Repeating Rows at the Bottom of the Page

ericuk

New Member
Joined
Dec 21, 2005
Messages
1
Hi All

I'm sure someone has asked this question before but I just can't seem to find the answer to it.

I'm aware that the same can be done for the top of the page in the Page Setup option but how can I actually write a VBA codes to do the same for the bottom of the a page.

I know you can somewhat achieve this by using the footer but this option is no good for me as the cells within the rows have different values (text, numbers etc) and formattings (border, colour etc).

I'd be really appreciated if you could help me out on this.

Many thanks in advance

Eric
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,118,110
Messages
5,570,250
Members
412,313
Latest member
pauloalex
Top