insert picture problem

G

Guest

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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox1 is DELETED(!?) when Me.Pictures(1).Delete runs in my macro 7
image insertion 1
Insert Picture using Macro 10
inserting pictures 2
" Select method of range class failed" if sheet not on top 4
Macro to insert picture from specific folder 0
Problem with inserting picture. 3
Insert picture 1

Top