Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in the footer?
Is there a way to reference a cell in the footer? I want it to equal cell(s)
in that sheet or another sheet in that book. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in the footer?
Hi,
No. However you can run code to do that: The following code puts the contents of cell A1 of Sheet1 into the left heade Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("A1") End Sub 1. To add this code to your file, press Alt+F11, 2. In the VBAProject window, top left side, find thisWorkbook under your file name and double click it. 3. Paste in or type the code above. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Haydie-lady" wrote: Is there a way to reference a cell in the footer? I want it to equal cell(s) in that sheet or another sheet in that book. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functions in the footer?
I can't get it to work, but I don't work with codes very often either. bummer
"Shane Devenshire" wrote: Hi, No. However you can run code to do that: The following code puts the contents of cell A1 of Sheet1 into the left heade Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("A1") End Sub 1. To add this code to your file, press Alt+F11, 2. In the VBAProject window, top left side, find thisWorkbook under your file name and double click it. 3. Paste in or type the code above. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Haydie-lady" wrote: Is there a way to reference a cell in the footer? I want it to equal cell(s) in that sheet or another sheet in that book. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple functions, conditional functions | Excel Worksheet Functions | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
Excel footer to look like Word footer? | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |