Outputting runtime macro to footer of Excel

[Marcke]

Hi all,

How can I output the time my macro last ran to the left side of my custom footer?

Thanks in advance for the help,

Wannes

[Artik]

The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
Write what you want to do next.

Artik

[Bob Phillips]

You would need to declare a public variable, and each time the macro runs update that variable with thetimestamp. You can then use the variab le in your footer with a BeforePrint event.

There is nothing automatic or built-in to tap into.

[Marcke]

You would need to declare a public variable, and each time the macro runs update that variable with thetimestamp. You can then use the variab le in your footer with a BeforePrint event.

There is nothing automatic or built-in to tap into.

Thanks for the tip. I wil use a global variable. How do I alter only a part of the footer?

[Artik]

Worksheets("Sheet1").PageSetup.CenterFooter = public_Variable Or LeftFooter, or RightFooter.

Artik

[Marcke]

Hi,

Thanks for the help.

I have one more question: if i close the excel file, is the value of my global variable then lost? Otherwise I'll store the value in a named range.

Kind Regards,

Wannes

[Artik]

if i close the excel file, is the value of my global variable then lost? Yes, you lose the value of the variable.

Artik

[Marcke]

How do can I add an Enter in this footer?

[lucas]

Use CHR(13) to insert a carriage return character


ActiveSheet.PageSetup.CenterHeader = "First line" & Chr(13) & _
"Second line"