ExcelBanter - How do I copy cell contents to footer in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I copy cell contents to footer in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/193183-how-do-i-copy-cell-contents-footer-excel.html)

Access novice

How do I copy cell contents to footer in Excel

I would like to copy the contents of a cell into the footer of an Excel
worksheet.

Jarek Kujawa[_2_]

How do I copy cell contents to footer in Excel

Sub Footersss()
With ActiveSheet.PageSetup
.CenterFooter = ActiveCell.Text
End With
End Sub

HIH

All times are GMT +1. The time now is 10:52 PM.