Thanks, mcmahobt!
I am familiar with the website that you pasted, but that is not exactly what I am looking for. That does not help me resize and place apicture based on an existing image (or at least I don't think it does).
Concerning your code -- I can't get this to work, so am not sure if it can accomplish the task. How do I call the new image? How does the code identify the existing pictures location and size? . Thanks for the input!
In case it helps, let me be a little more clear about my intent: I have a "backend" excel document which houses the locations of pictures for different inspections (so imagine cell A1 = C:\user\mydocuments\pic1.jpg, and A2 = C:\user\mydocuments\pic2.jpg and so forth). When the user runs my macro, they will be creating hundred of reports based on a "report template" that they will create. That is why I need to define a picture to a certain location -- so the macro will know where exactly to paste pictures for subsequent reports (what I'm thinking is the macro will look for "picture1" or something and replace it with the picture from the backend).
Bookmarks