Thread: alternating between left and righ headers, odd and even pages or leafs using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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.






Reply With QuoteReply With Quote