Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I copied the basic listing and tryed to have it working for all the headers but it works only for the first one. What do I wrong? Thank you for helping Sub InsertCellsDataInHeader() With ActiveSheet ..PageSetup.LeftHeader = .Range("A1").Text ..PageSetup.CenterHeader = .Range("A2").Text ..PageSetup.RightHeader = .Range("A3").Text End With End Sub -- dilettante |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximum Text in Cells for Printing | Excel Discussion (Misc queries) | |||
How to insert Header will full text across page | Excel Discussion (Misc queries) | |||
Displaying & Printing cells with lotsa text | Excel Discussion (Misc queries) | |||
Slanted Text in header cells | Excel Discussion (Misc queries) | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |