Repeat rows at bottom of page

[WorkingMomx3]

I've made a quick search of the posts here and haven't found something that addresses my needs. A co-worker has several rows of data (footnotes actually) that he would like printed at the bottom of each page. The total length of the notes exceeds 255 characters. Is there a way of selecting these rows to be repeated at the bottom of the page similar to the way Page Setup allows you to select rows to be repeated at the top of the page?

Thanks.

[Ivan F Moala]

On 2002-05-23 08:06, WorkingMomx3 wrote:
I've made a quick search of the posts here and haven't found something that addresses my needs. A co-worker has several rows of data (footnotes actually) that he would like printed at the bottom of each page. The total length of the notes exceeds 255 characters. Is there a way of selecting these rows to be repeated at the bottom of the page similar to the way Page Setup allows you to select rows to be repeated at the top of the page?

Thanks.

AFAIK there is no way to do this.
The closest I could get was 253 characters
into the Footer vai Code.

If it's any use to you then:
Where A1 & A2 house the text..just change to
your range to include in the Footer....and
make sure the print area doesn't include this range...

Sub FormatFooter_Codes()

With ActiveSheet.PageSetup

           .CenterFooter = Range("A1").Text & Range("A2").Text

End With



End Sub

[Russell Hauf]

An ugly solution:

Print your footer first - from Excel or Word, just get it close to the bottom of the page. Then set your bottom margin high enough to not print over the footer, and print onto the same pages that you already printed the footer on.

Sorry that I can't think of something better,

Russell