Print page with cell as footer reference

[Hellboy]

Hi

Is it possible when printing in excel, to have a cell as a footer. I know it's possible to have the page, the file name, the sheet name. But for a cell ????

Thank's

Philippe

[dominicb]

Good afternoon Hellboy

Certainly is - but you will need to use VBA to achieve it.

With ActiveSheet.PageSetup
.LeftFooter = Worksheets("Sheet1").Range("A1").Value
End With

This would do the trick. Obviously, if you want the footer on the right or in the centre you would use the CenterFooter or RightFooter property.

HTH

DominicB

[Hellboy]

Hi dominicb

Wow ! Thank's a lot.

Philippe

[dominicb]

Hi Philippe

You're welcome. And thanks for the feedback.

DominicB