VBA Picture insert from directoy in merged cell and scaling

Thanks PCI!

That helps a lot. I tested it and 3 things which doesn't fullfill my needs:

1. Sizing of the pictures: the pictures are streched out to the whole size of the cellrange (MyPicture). The picture scaling must be set to "aspect ratio". Max. size of the picture must be appr. 95% of the height of cellrange ("MyPicture);

2. Location of the picture must be centered in "Mypicture";

3. The picture must be loaded/updated automatically when the cell value I13 changes. Now the picture changes after switching the worksheet.

I added some sample pictures to the example.