Image print based on value

[MaxBrit]

Hi

We have a worksheet that has data for a schematic in groups of 10 rows and have code that prints each set of 10 rows onto a separate page.

Is it possible (and how <g>) to print an associated image that would depend on a cell value for each group? This is required to be on the same sheet as the data.
Landscape print with data at top of page image below data.

We do not require the image to be displayed on the worksheet just added at print time.

The images are jpg stored in local folder.

Thanks for any help

Maxwell

[MaxBrit]

Have modified to store images within workbook and used ideas from

http://www.rondebruin.nl/print.htm#non-contiguous

To copy both ranges to new sheet and then delete and then move onto the next section.

Max