VBA for Excel Footer using a range

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

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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!!

HA! I think I got this myself. I'm going to leave this for others who have the same issue. I will have to mess with the margins a bit to get it to fit properly.

Please Login or Register  to view this content.