Macro in Excel 2010 doesn't recognize Footer Codes RRS feed

  • Question

  • Hi, 

    I have a footer macro issue in Excel 2010. 

    Even after commenting out the "Application.PrintCommunication" line, the macro doesn't recognize the complete code for footer. 

    It is a simple code: 

     .LeftFooter = "&F &A"
     .CenterFooter = "Page &P of &N"
     .RightFooter = "&D &T"

    But after running the macro, it only prints the 1st half (e.g. prints the file but missed the tab name). Does any one know if there is any workaround for this issue? 



    Friday, January 15, 2016 5:49 PM