| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing the contents on a named range in the Header of an Excel s
I want to print the contents of a named range in the header of my document when I go to print the worksheet. In the custom header options, this is not available. Is there a way to do this and can you tell me how? Thanks! Dots |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing the contents on a named range in the Header of an Excel s
Assuming that the Name blockk has already been assigned to some cell: Sub Macro1() ActiveSheet.PageSetup.CenterHeader = Range("blockk").Value End Sub -- Gary''s Student - gsnu200819 "Dots" wrote: I want to print the contents of a named range in the header of my document when I go to print the worksheet. In the custom header options, this is not available. Is there a way to do this and can you tell me how? Thanks! Dots |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Range in Customer Header | Excel Discussion (Misc queries) | |||
| Printing the contents on a named range in the Header of an Excel s | Excel Programming | |||
| Can you write the contents of an Excel Named Range to Word? | Excel Programming | |||
| Using a named range in a header with VBA? | Excel Discussion (Misc queries) | |||
| Named Range in Center Header | Excel Programming | |||
Hybrid Mode
