Print with cell value

  • Thread starter Thread starter Freshman
  • Start date Start date
F

Freshman

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.
 
File > Page Setup > Sheet, you can choose the Print Area here.
Does that help?

Regards,
Ryan---
 
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
 
Back
Top