How do I copy cell contents to footer in Excel

  • Thread starter Thread starter Access novice
  • Start date Start date
A

Access novice

I would like to copy the contents of a cell into the footer of an Excel
worksheet.
 
Sub Footersss()
With ActiveSheet.PageSetup
.CenterFooter = ActiveCell.Text
End With
End Sub

HIH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy of Header-Footer in Excel 3
copying Footer 4
Headers & Footers _auto update info from a cell in the worksheet 4
How do I use an Excel cell in footer 2
How do i include the contents of a spreadsheet cell in the footer? 1
How do I copy a custom footer to other sheets 1
Insert cell contents into header/footer 7
Add a cell reference to a page footer 1

Back
Top