Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 09, 08:25 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 1
Default Adding a cell reference to a footer?

Have created a worksheet in which the user fills out info and it carries over
into the other tabs. Is there a way to have one of the cells in the first
worksheet referenced as part of the footer for all of the corresponding tabs?

  #2   Report Post  
Old December 2nd 09, 09:12 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Adding a cell reference to a footer?

Sub Cell_In_AllFooters()
Dim WS As Worksheet
For Each WS In ActiveWorkbook.Sheets
WS.PageSetup.CenterFooter = Sheets("Sheet1").Range("A2").Value
Next
End Sub


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 12:25:01 -0800, mercil
wrote:

Have created a worksheet in which the user fills out info and it carries over
into the other tabs. Is there a way to have one of the cells in the first
worksheet referenced as part of the footer for all of the corresponding tabs?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Header or Footer - Reference a Cell enna49 Excel Worksheet Functions 5 September 11th 08 04:07 AM
Add a cell reference to a page footer scheduling Excel Discussion (Misc queries) 1 August 12th 08 10:42 PM
Reference a footer in a cell Elizabeth Excel Worksheet Functions 1 January 30th 07 05:31 PM
Excel footer reference to cell in workbook mlh97 Excel Discussion (Misc queries) 1 March 1st 06 04:27 PM
How can I insert a cell reference in a footer (eg for variable foo wngg001 Excel Discussion (Misc queries) 1 December 15th 04 10:56 AM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017