Image Resize

Dear Expert,

I need your help for resize images in active sheet,in active sheet have images in different/different size.

I want to do equal size for all the images in same cell.

refer attached sheet please,cell A first images size is perfect so same size i want for all the images.

Please help on this thanks.


Regards
Imran

While this can done as below, you will also want more than this I suspect.

The other properties that you will want set are likey the shape's Top and Left. You will also need to compute the offsets for the master shape cells difference between the Left and Top for the cell and the shape objects.

One can even get into issues where a row or column for the shape's TopLeftCell needs to be set.

Please Login or Register  to view this content.

Dear Sir,

i am running same coding but expect 1st images,rest of the images is coming in same size same as 1st imges which i want but not coming inside cell.

the images is going outside.

why i want to do this from macro actually i have big data in same format,all the images size is different thats i want to resize all the images through macro and images come in same cell inside not goes outside.

Please help.

Guess this is one of the 1% of the times that I can read minds. I had already explained the concepts and gave you the keywords.

Please Login or Register  to view this content.

thank You Sir - this worked perfect