Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

**Jhon Mustofa** · 12-30-2018, 03:59 AM

hi expert.

i have need macro code to resize multiple pictures in different cell.
my target , that macro can work on all pictures and SAME SIZE.
maybe this code help, but i don't know how to change code that to be SAME SIZE
this code :

Please Login or Register  to view this content.

i attachment file to easy understanding..

any help thanks in advance...

john m

**Richard Buttrey** · 12-30-2018, 07:57 AM

What size do you expect them to be? If you set one of them to the size you wish and the reupload the wb no doubt we can help further

**mjr veverka** · 12-30-2018, 08:37 AM

Originally Posted by Jhon Mustofa

... macro code to resize multiple pictures in different cell ...

It will be difficult to center pictures in cells (with a change in cell size), because you are using merged cells.

**Richard Buttrey** · 12-30-2018, 09:22 AM

Are we yet sure exactly how large the picture should be. The OP merely mentions the size, not what he sze should be or indeed where it should be positioned relative to any cell. Perhaps the OP will enlighten us.

**mjr veverka** · 12-30-2018, 09:53 PM

Originally Posted by Richard Buttrey

... Perhaps the OP will enlighten us ...

hmm ... perhaps ... maybe ... suppose ...

**Richard Buttrey** · 12-30-2018, 10:00 PM

Hi,

Not quite sure how to take that. The question was really what size should it be IN the Workbook?

**Jhon Mustofa** · 12-31-2018, 11:02 AM

maybe this picture can more explainedbefore ok.png

my expected/desired result
after ok.png

for resize no matter but i want that picture centered...

**Jhon Mustofa** · 12-31-2018, 11:06 AM

Originally Posted by porucha vevrku

It will be difficult to center pictures in cells (with a change in cell size), because you are using merged cells.

hi...

how if the cell not merged? not using merged cells.

**Richard Buttrey** · 12-31-2018, 12:10 PM

Assuming the cells are unmerged then does this help

You'll need to create a loop to select the cells and the picture names

Please Login or Register  to view this content.

**mjr veverka** · 12-31-2018, 11:47 PM

Originally Posted by Jhon Mustofa

... not using merged cells ...

using ... using ...

If you would like to center an image in unmerged cell:

Please Login or Register  to view this content.

**daboho** · 01-01-2019, 01:50 AM

Please Login or Register  to view this content.

**daboho** · 01-01-2019, 01:59 AM

or you can do like this

Please Login or Register  to view this content.

Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

LinkBack

Thread Tools

Rate This Thread

Display

Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Re: Resize Multiple Pictures in cell With Result Must Same Size [4 pict)

Thread Information

Users Browsing this Thread

Similar Threads

Excel 2007 : Automatically resize an inserted picture to match cell size

[SOLVED] Excel 2010 - resize multiple linked images to be the same size

Adjusting pictures to fit a specific size cell

Automatically resize numerous images to a cell size

Macro to autom. display images from URL, resize picture and move and size with cell

Auto resize of pictures

Copy and Resize Multiple Pictures then paste

Bookmarks

Bookmarks

Posting Permissions