Returns a section of the header.

public HeaderFooterSection GetHeader(HeaderFooterSection.Section section)
Public Function GetHeader(ByVal section As HeaderFooterSection.Section) As HeaderFooterSection

The section of the header to return

A HeaderFooterSection object representing the specified section of the header

          //--- Get the right header of the first worksheet
          HeaderFooterSection myLeftFooter = WB[0].PageSetup.GetHeader(HeaderFooterSection.Section.Right);
          '--- Get the right header of the first worksheet
          Dim myLeftFooter As HeaderFooterSection = WB[0].PageSetup.GetHeader(HeaderFooterSection.Section.Right)

You can use a HeaderFooterSection object to manipulate a given section of the header or footer, such as the text or image that appears in that section. Note that the total length of the text in all sections of the header may not exceed 255 characters.