That will work, but I am looking for something more automated. I would like the picture to change when I change the path in column A to another picture.
Thanks,
Mark Bryant
Mark,
You can set up a 'Worksheet_Change' procudure that will get updated links when you change them.
With the 'Control Toolbox' toolbar up, you can select the Image button and click and drag it to where you want it on your page. Right click this and select Properties. Click Picture and select the picture you want. To show the whole picture, Click PictureSizeMode and select
1-fmPictureSizeModeStretch.