Print Repeating Rows at the Bottom of the Page

[ericuk]

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