| 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. |
| 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 | |||
Threaded Mode
