Bernie,

Thanks for the help this works great,
By any chance would you know how to alter this code so i can place the pictures on a sheet with a specific name
then call that sheet to cross referance the pictures



[quote=Bernie Deitrick;712531]Visit

http://www.contextures.on.ca/excelfiles.html#DataVal

and download ClipArtEvent.zip

for some examples of using pictures in a file.

HTH,
Bernie
MS Excel MVP