How to Include a specific Cell's Contents in a footer Excel 2003

  • Thread starter Thread starter CH-DE-FDS APRIL
  • Start date Start date
C

CH-DE-FDS APRIL

I want to Include a version ID (contained in a specific cell) as part of a
footer in Excel 2003 what format should I use?

Thanks
 
Try this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = Range("$A$1")
End Sub

Mike
 

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

Back
Top