| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header or Footer - Reference a Cell | Excel Worksheet Functions | |||
| Add a cell reference to a page footer | Excel Discussion (Misc queries) | |||
| Reference a footer in a cell | Excel Worksheet Functions | |||
| Excel footer reference to cell in workbook | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
Linear Mode
