Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternating between left and righ headers, odd and even pages or leafs using VBA
I have reports that will printout to 1 or more pages.
I use the following code to determine how many pages there will be ActiveSheet.VPageBreaks.Count Is there a way of alternating the position of the header. I.e. If page 1 (odd) then ..LeftHeader = "My Header" RightHeader = "" Else if even (2,4,6 etc) page then ..LeftHeader = "" ..RightHeader = "My Header" I am currently printing into one single .pdf with multi pages therein. It is fine if the header is in the same position but I would like to do something a little fancy. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternating between left and righ headers, odd and even pages or l
there is no support for it.
-- Regards, Tom Ogilvy "webbygeeza" wrote: I have reports that will printout to 1 or more pages. I use the following code to determine how many pages there will be ActiveSheet.VPageBreaks.Count Is there a way of alternating the position of the header. I.e. If page 1 (odd) then ..LeftHeader = "My Header" RightHeader = "" Else if even (2,4,6 etc) page then ..LeftHeader = "" ..RightHeader = "My Header" I am currently printing into one single .pdf with multi pages therein. It is fine if the header is in the same position but I would like to do something a little fancy. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternating between left and righ headers, odd and even pages or l
Thank you Tom, short and precise.
My guess is then to set up page for printing individually by hide and unhide columns per print setup. Best wishes, Ray Can stop losing sleepo "Tom Ogilvy" wrote in message ... there is no support for it. -- Regards, Tom Ogilvy "webbygeeza" wrote: I have reports that will printout to 1 or more pages. I use the following code to determine how many pages there will be ActiveSheet.VPageBreaks.Count Is there a way of alternating the position of the header. I.e. If page 1 (odd) then ..LeftHeader = "My Header" RightHeader = "" Else if even (2,4,6 etc) page then ..LeftHeader = "" ..RightHeader = "My Header" I am currently printing into one single .pdf with multi pages therein. It is fine if the header is in the same position but I would like to do something a little fancy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Outline/group 2 columns- what puts the control on the left vs righ | Excel Discussion (Misc queries) | |||
How do I make the auto fill handle to input data from left to righ | Excel Discussion (Misc queries) | |||
how to copy down formulars into same column by a row left to righ | Excel Discussion (Misc queries) | |||
How do I print row labels on alternating pages of an Excel workshe | Excel Discussion (Misc queries) | |||
How to only print row labels on alternating pages of a worksheet? | Excel Programming |