If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I use Merge Fields in Excel Headings?
I would like to use an actual cell item in a heading. Is this possible? So
far all I get is the actual formula. |
#2
|
|||
|
|||
Can I use Merge Fields in Excel Headings?
On Jan 29, 8:40 pm, Jeanette
wrote: I would like to use an actual cell item in a heading. Is this possible? So far all I get is the actual formula. Try this link, which explains how to do it using VBA code:- http://www.cpearson.com/excel/headfoot.htm HTH Matt Richardson http://teachr.blogspot.com |
#3
|
|||
|
|||
Can I use Merge Fields in Excel Headings?
Jeanette
Take your pick from these macros or combine parts of each into one. Sub CellInFooter() With ActiveSheet .PageSetup.CenterFooter = .Range("A1") End With End Sub Sub Cell_In_AllFooters() Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets ws.PageSetup.CenterFooter = ws.Range("A1") Next End Sub Sub CellInFooter22() With ActiveSheet.PageSetup .LeftFooter = "&""Algerian,Regular""&16" & Range("A1") End With End Sub Gord Dibben MS Excel MVP On Tue, 29 Jan 2008 12:40:04 -0800, Jeanette wrote: I would like to use an actual cell item in a heading. Is this possible? So far all I get is the actual formula. |
Thread Tools | |
Display Modes | |
|
|