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




"Big Rick" <BigRick@discussions.microsoft.com> wrote in message
news:4DED8A40-CD69-4804-BBE4-6A1F3503F1F9@microsoft.com...
> 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

[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

"Big Rick" <BigRick@discussions.microsoft.com> wrote in message
news:4DED8A40-CD69-4804-BBE4-6A1F3503F1F9@microsoft.com...
> 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]

> 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" <ng@officearticles.com> wrote in message
news:uGSdwy%231FHA.1132@TK2MSFTNGP10.phx.gbl...
> 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" <BigRick@discussions.microsoft.com> wrote in message
> news:4DED8A40-CD69-4804-BBE4-6A1F3503F1F9@microsoft.com...
>> 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
>
>

[Anne Troy]

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

"Chip Pearson" <chip@cpearson.com> wrote in message
news:eJ3z92%231FHA.3924@TK2MSFTNGP14.phx.gbl...
>> 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" <ng@officearticles.com> wrote in message
> news:uGSdwy%231FHA.1132@TK2MSFTNGP10.phx.gbl...
>> 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" <BigRick@discussions.microsoft.com> wrote in message
>> news:4DED8A40-CD69-4804-BBE4-6A1F3503F1F9@microsoft.com...
>>> 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
>>
>>
>
>

[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" <chip@cpearson.com> wrote in message
> news:eJ3z92%231FHA.3924@TK2MSFTNGP14.phx.gbl...
> >> 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" <ng@officearticles.com> wrote in message
> > news:uGSdwy%231FHA.1132@TK2MSFTNGP10.phx.gbl...
> >> 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" <BigRick@discussions.microsoft.com> wrote in message
> >> news:4DED8A40-CD69-4804-BBE4-6A1F3503F1F9@microsoft.com...
> >>> 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
> >>
> >>
> >
> >
>
>
>