title: Different first page header footer macro excel
body: <p>I am using the below macro to format my excel file headers. I need my first page header to be different from the second page. I want to add "Continued"after the first page in the header. Could you please help. Thank in Advance.</p>
  
  <pre><code>shDD.Select
  With ActiveSheet.PageSetup
      .LeftHeader = "&amp;""Arial,Bold""&amp;12" &amp; Range("EIIname").Value &amp; Chr(10) &amp; "&amp;5" _
      &amp; Chr(10) &amp; "&amp;10" _
      &amp; Range("HdrDDn").Value &amp; Chr(10) _
      &amp; "&amp;""Arial,bold""&amp;10" &amp; Range("HdrPeriod").Value &amp; Chr(10)
  End With
  </code></pre>