400 error, picture insert, resize

wow works great, thanks a lot. just one more question

is it possible to delete any picture already in the selected range first before putting the new picture in?

Chris

Glad it helped Chris. I don't think there is a way to directly reference pictures within a range, although you could cycle through each shape within a worksheet, and determine whether any extents of a picture fall within the extents of the range, deleting as appropriate.
Dave