Named Range at bottom of every page

Hello,

Me again with another annoying 'Why hasn't microsoft added this' issues

Is there a way of printing a named range to the bottom of every page?

I know you can use the Print Titles for the top but I also need a footer that is already formatted (pre set from Sheet2!A1:I8) and should appear on each printed page in the same format. It basically is an invoice footer.

Any help would be appreciated as per normal

You can use the chart object to export an image and then pull it back into the footer.

Please Login or Register  to view this content.

OMG!! I sincerely apologise for my delay. I thought I responded and closed this thread months ago.

Many thanks ByteMarks, works perfectly.