Vba resize copy and paste

[Mousepad522]

Hi I'm new to VBA in Excel
Here is my problem.
I have a spreadsheet that is three cards that are the same and it already contains images. I need to resize and center one image then copy that image, and place it in the next card below and so on.

I would like to just have the vba change the height and width on the current image there then center then take that image and replace the rest like it. All in one spreadsheet.

Any help would be appreciated!!

 

[jolivanes]

Must be me but the whole thing is clear as mud to me.

 

[Mousepad522]

Must be me but the whole thing is clear as mud to me.

That's how I feel about Excel! Lol.

I need to resize one image. Center.
Then replace another picture with the new one.

 

[jolivanes]

If you're not willing to properly explain, I can't help you.
Good luck.

 

[jolivanes]

Is this the same problem?

VBA for resize and align picture.

Hi, I want to make a VBA Macro in Excel for resizing and centering pictures that are already in a worksheet. The pictures are in cells. I was hoping to just adjust the picture height and width. Any help would be great, I'm new to macros.

www.mrexcel.com