I think you would have to either copy it and paste or use your insert command
and resize it.



--
Regards,
Tom Ogilvy


"kidev" wrote:

How can I insert the same picture into several worksheets:
* without using the clipboard; and
* without re-loading the same file repeatedly; and
* re-sizing the picture to fit within a designated range.

I am currently using the pictures collection on each
sheet like this:
Dim pic as excel.picture
pic = activesheet.pictures.insert("pic.jpg")
' set pic.height and pic.width to resize
This lets me resize it but I am not sure about the
other two issues.