Change Header or Footer using VBA in Excel 2007

[ssingh75]

Hi All,

Please let me know how can i change Header or footer in excel 2007 using VBA?

 

[jolivanes]

Something like this maybe.

   With ActiveSheet.PageSetup
   '   .CenterFooter = ""    <---- To delete current CenterFoooter if required
      .CenterFooter = "Hello, how are you?"
   End With