2 Line Right Header suddenly not working anymore.

[JohnZ1156]

I have a 2 line Right header set up.
Suddenly it's not working, but I don't know what changed.

I'm now getting this error message.
Run-time error '1004':
Unable to set the RightHeader property of the PageSetup class.
Here's the line in my VBA macro that it doesn't like.
Application.ActiveSheet.PageSetup.RightHeader = "&""Arial""&20" & "Page &P of &N " & _
Chr$(10) & Format(ActiveSheet.Range("J1").Value, "$#,##0.00 ")

 

[MARK858]

Do you have any sheet or workbook protection set?

 

[Jeffrey Mahoney]

What is in cell J1? Error? The macro worked for me

 

[RoryA]

Do you have a default printer set?