Placing Logos in Printed Pages

[dai50]

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

[dai50]

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

After posting this message I discovered that I could insert a picture into the page header. This provides a solution to my problem but would prefer a VBA solution for better control.

Dai

[dai50]

After posting this message I discovered that I could insert a picture into the page header. This provides a solution to my problem but would prefer a VBA solution for better control.

Dai

Its amazing how working with a problem clears the mind. I now have a macro which writes to the page header and stuffs the logo into the title area. Just needed define the logo:

#
ActiveSheet.PageSetup.RightHeaderPicture.Filename = "C:\DATA\LOGO.JPG"
.
.
.
With ActiveSheet.PageSetup
.RightHeader = "&G"
.
#

The &G refers to the picture and prints fine.

Dai