Adding a static image to Excel clipboard data?

[Scr1pter]

Hello guys,

I have an Excel file where I often create image files directly from the Excel content.
Originally I took screenshots with Gdip, but creating an image with Gdip is much faster and easier.

Anyway, my problem is that all sheets contain:
Data (which is from sheet to sheet different) and a static image.
It looks like this (just an example):


Instead of having this static image in ALL sheets, I would rather have it just 1 in separate sheet.
The question is, can I just use something like:

Code: Select all

ws.range("A1:G17").copy ; Copy everything in that range (DATA)
xl.sheets("Tabelle2").range("A1:D18").Copy ; Copy everything in that range (IMAGE)

But I would need to put those Clipboard contents together, so that they are like the image from above.

I know I can merge images with Gdip, but
1) Gdip is still difficult for me and
2) The script becomes unneccesarily bigger and complexer

I could add this static image to all worksheets (in worst case).
Only disadvantage is that loading the Excel file takes some seconds.
(And it's a bit time-consuming + changing the image will take time as well.)

Can you help me out?
Thanks in advance!

Regards