Trying to get this method to work, but no luck. Is there something missing from the instructions (perhaps a step that's obvious to experts, but not to others)?

http://www.mcgimpsey.com/excel/lookuppics.html

The sample sheets works, but when I try to create my own from the ground up, no luck.

I make sure the VB code points to the correct cell (example states F1). I ensure that the named range is spot on.

I've tried it with pictures named 'Picture 1', 'Picture 2' etc. and tried it with other names. The closest I get is that all the images disappear, but no image (regardless of the contents of the VLOOKUP reference cell appears. Instead, I get the text 'Picture 1' etc.

Do I need to name the pics or declare them somehow?

Thanks.

Edit: Excel 2007