Print with cell value

[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.

 

[ryguy7272]

File > Page Setup > Sheet, you can choose the Print Area here.
Does that help?

Regards,
Ryan---

 

[Gord Dibben]

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

 

[Freshman]

Hi 7227,

Thanks for your help. Regards.

File > Page Setup > Sheet, you can choose the Print Area here.
Does that help?

Regards,
Ryan---

 

[Freshman]

Hi Gord,

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

 

[Gord Dibben]

Good to hear

Thanks for the feedback.

Gord

Hi Gord,

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