EMBEDDING CELL REFERENCE(S) IN HEADER/FOOTER

[advplan]

How can I embed a cell reference as part of a header or footer?

 

[Damon Ostrander]

Hi advplan,

Sorry, but you can't. Headers and footers are text strings, and nothing more. The only way to write the value of a cell into a header and footer is to use a macro to insert it, say, whenever the cell value changes.

 

[sykes]

Hi advplan

Welcome to the board!

It may be possible, depending on what you want to do. For example I use a macro to update the "issue number" on a worksheet footer before it's printed out, or automatically, before the workbook is closed.
The issue number is stored in a cell on a worksheet, and updated by one each time the macro runs, after which a message box appears informing the user of the issue number change.

Is this the sort of thing you're after?

Kindest

Sykes

_________________
....and the meek shall inherit the earth...
(but not the mineral rights!)
This message was edited by sykes on 2002-10-03 14:23