How can I repeat cells at the bottom of a worksheet when I print it?

Excel has no "rows to repeat at bottom" feature.

You either copy the row or cells to just above pagebreaks or add the cells to
the Footer.

For adding a cell value to a Footer you will need a macro.

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP


On Wed, 16 Apr 2008 09:53:01 -0700, LSGBrydon
wrote:

How can I repeat cells at the bottom of a worksheet when I print it?