ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Include a specific Cell's Contents in a footer Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/210548-how-include-specific-cells-contents-footer-excel-2003-a.html)

CH-DE-FDS APRIL

How to Include a specific Cell's Contents in a footer Excel 2003
 
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

Mike H

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

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

Mike

"CH-DE-FDS APRIL" wrote:

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



All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com