Custom Footers.

[Big Rick]

As I have heard different stories of wether it is possible to put the
contents of a cell into a custom footer, please can someone tell me if it is
possible or not.
The cell contents simply contains text.

Thanking you in anticipation
<><><><><><>
Big Rick

 

[Chip Pearson]

You need VBA to do this. In the ThisWorkbook code module, use
code like the following:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = Range("A1").Text
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Anne Troy]

Hi, Big guy. Here's some exact instructions. Just change LeftHeader to
LeftFooter, or whatever.
http://vbaexpress.com/kb/getarticle.php?kb_id=739
And you can get more information about it here.
http://www.cpearson.com/excel/headfoot.htm
************
Anne Troy
www.OfficeArticles.com

 

[Chip Pearson]

And you can get more information about it here.

http://www.cpearson.com/excel/headfoot.htm

I'm glad someone remembered that page. I had completely forgotten
about it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Anne Troy]

LOL. How you doing, Chip?
************
Anne Troy
www.OfficeArticles.com

 

[Big Rick]

Many thanks for your quick responce.
I am forever grateful.