Hi all!!

I have a range in Excel I would like to print on the footer of each page, whenever I attempt the range function it only shows me the first cell. It lists a summary for the table that I have created. I put the summary range in cells O3 to P6. I've tried 

.range("O3:P6") 
.range("O3", "P6")
neither are working. I even tried naming the range "ABCCodes" and that isn't working either. I've tried it with and without quotes etc. 

Sub AddFooter()

With ActiveWorkbook.ActiveSheet.PageSetup
    .LeftFooter = Range("ABCCodes")
    .CenterFooter = "|&P of &N|"
End With

End Sub
The page numbers work fine

I'm running Excel 365. I'm not sure if this is possible or not, Google wasn't too helpful only gives me one cell to input which is what it's doing!!