VBA Runtime error '1004' code on formatting page footer/header

Question

When I run the VBA code to set-up and format the footer for the Excel page, I get 1004 Runtime error - "Unable to set the CenterFooter property of the PageSetup class". The code is below:

With Sheets("Letter").PageSetup
        .LeftFooter = "&""Arial,Regular""&6" & Sheets("Footer").Range("A1")
        .CenterFooter = "&""Arial,Regular""&6" & Sheets("Footer").Range("E2")
        .LeftHeader = "&""Arial,Regular""&8" & Sheets("Footer").Range("I5")
End With

The code refers to the specific cells in the "Footer" named spreadsheet to pick-up the wording for left and center footers, as well as for the left header of the page.

When I run the code it picks up the left footer, but the error window pops-up on the .CenterFooter line. If I comment that line, LeftFooter and LeftHeader work perfectly.

I also noted that, if I simplify the code taking out the formatting piece like below, it works perfectly:

With Sheets("Letter").PageSetup
        .LeftFooter = Sheets("Footer").Range("A1")
        .CenterFooter = Sheets("Footer").Range("E2")
        .LeftHeader = Sheets("Footer").Range("I5")
End With

I'm relatively new in VBA coding, hence appreciate if your answer would be easy to understand.