I'm using a macro to format information on a sheet which has variable number of columns and rows. I've also set the left 3 columns to repeat on each page as well as the top 6 rows which produces the output I need but my client also needs a logo on the top right corner of each page. I can place the logo on the first print area page but when printing multiple pages from one sheet (as many as 6 A4 pages) the logo only appears on the first page and none of the subsequent pages.

Any ideas how the logo can be incorporated in the repeating header area?

Many thanks for any responses.

Dai