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

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
 
M

Mike H

Try this

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

Mike
 
Top