Paste image to worksheet cell then reduce its size

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,226
Office Version
  1. 2007
Platform
  1. Windows
Afternoon.

On my worksheet i have a cell area of which i insert a image.
The image is a little bigger than the cell range but i need to keep moving / resizing it to fit etc.
I insert 4 images down the page so each is then out of line & looks a mess.

Below is the first cell area in question.

What i would like to do is to insert the photo into this area but not sure if i should merge these cells or have some kind of code "or both" so that when the image is inserted its automatically resized so it looks neat / centered etc.

The cell area is currently 361 x 132

Please advise.
 

Attachments

  • 6919.jpg
    6919.jpg
    39.5 KB · Views: 19

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
No, Just copy the image and run the macro, enter VBA and press F5
 
Upvote 0
afternoon,
Now working fine.

I put the code on buttons & altered the cell area for each.

Works very nice.
Thanks
 
Upvote 0
I'm glad to help you. Thanks for the feedback. ? (y):cool::biggrin:
 
Upvote 0

Forum statistics

Threads
1,214,944
Messages
6,122,387
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top