Hi - I'm trying to get a picture to appear on a worksheet that will dynamically change based on the contents of a cell. I can get it to work ok using named ranges and the camera option, but I'm limited to 255 chanacters and 7 nested IF statements in the 'Refers to' option of my name.

Can anyone recommend a way to do this please using VB or something simillar?

Example would be:

Cell with a name in it, and depending on the name in the cell the persons photo to appear on the same worksheet. All photos to be stored in the Workbook.

Thank you.