Good to hear

Thanks for the feedback.

Gord


On Sat, 5 Apr 2008 22:59:00 -0700, Freshman
wrote:

Hi Gord,

Thanks for your code and it works well. Thanks again.

"Gord Dibben" wrote:

Excel has no "rows to repeat at bottom".

You could place the contents of L1 & M1 in the Footer.

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("L1").Value _
& " " & .Range("M1").Value
End With
End Sub


Gord Dibben MS Excel MVP

On Tue, 1 Apr 2008 23:38:03 -0700, Freshman
wrote:

Dear expert,

In a worksheet, is there a way whenever I print the contents of any parts,
values of 2 fixed cells (say L1 & M1) will always be printed to the row two
rows under the last printed row? Please advise.

Thanks in advance.