Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert named cell in header
Hi! I have a workbook with multiple sheets using the same header. I'm trying
to insert the contents of a named cell from the first worksheet into the header that is used for all of the other worksheets. The first sheet is called Data Entry. The named cell is Target. The header would look like this: Company name: <Target Your help would be greatly appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert named cell in header
Sub Name_All_Sheets()
Set wkbktodo = ActiveWorkbook For Each ws In wkbktodo.Worksheets ws.PageSetup.RightFooter = "Company Name: " & Range("Target").Value Next End Sub Gord Dibben MS Excel MVP On Sun, 23 Sep 2007 09:16:01 -0700, Giggly4g wrote: Hi! I have a workbook with multiple sheets using the same header. I'm trying to insert the contents of a named cell from the first worksheet into the header that is used for all of the other worksheets. The first sheet is called Data Entry. The named cell is Target. The header would look like this: Company name: <Target Your help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Named Range Into a Cell | Excel Worksheet Functions | |||
How do I to refer to a (named) cell in Excel header/footer? | Excel Worksheet Functions | |||
How do I insert a link to a cell in a header in Excel? | Excel Discussion (Misc queries) | |||
Insert cell contents into header/footer | Excel Discussion (Misc queries) | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |