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

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




"Big Rick" wrote in message
...
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

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

"Big Rick" wrote in message
...
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

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" wrote in message
...
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

"Big Rick" wrote in message
...
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

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

"Chip Pearson" wrote in message
...
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" wrote in message
...
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

"Big Rick" wrote in message
...
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

Many thanks for your quick responce.
I am forever grateful.
--
Big Rick


"Anne Troy" wrote:

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

"Chip Pearson" wrote in message
...
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" wrote in message
...
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

"Big Rick" wrote in message
...
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