Paste picture

Bit of a noob question this but then.....seeing as I am a noob I suppose it fits.

My workbook (which is unfortunately too large to post) has 2 sheets that are giving me a problem. The first is a search criteria sheet with 4 rows of unlocked cells for users to enter criteria, and a search button (plus some other stuff that's irrelevant to this). The second is where the data from the search is displayed. This part works fine.

However.....a slight oversight on my part means I've only got 2 cells (quite large cells, but only two nonetheless) to play with to display what the actual search criteria was on the display sheet. I'm expecting users to want to print the display sheet, therefore I really need to display the search criteria on it but there's so much data to display I don't have a lot of room left.

Up til now what I've done is have a picture link on the display sheet that shows the range of cells on the 1st sheet, thereby showing the search criteria. And, of course, the picture link both updates automatically and is resized perfectly to fit into these 2 cells I've got spare.

The problem is......that when this picture link is there other code in the spreadsheet seems to run slower that it should, removing the picture link instantly speeds things up. So....I can't use a picture link and there's way too much data displayed on the second sheet to have the search criteria there as well in any other form.

What I'd like to do is instead of a picture link just paste a picture of the cells in question and when a user navigates away from the display page delete it again. The thing is I have no idea how to position a picture created in code or how to delete it again when I don't know it's name.

I've gotten as far as:

Range("E6:R13").Copy
Sheets("Assessments").Select
ActiveSheet.Pictures.Paste.Select

and after that I'm stuck. How do I position it in code at the same place every time and how do I delete it again?

While I can't post the workbook, I have attached 2 jpegs that show what I mean.


Oh P.S. Just to make it more difficult, this needs to work in all versions of excel from 2002 upwards.