automatically fit an image into merged cells for full width of merged cells

[Marcin4111]

Please Login or Register  to view this content.

Do you know how should I modify this code for uploaded picture to be scaled with locked aspect ratio for full width of merged cells?

[karedog]

Hi,

Delete these lines :

Please Login or Register  to view this content.

Regards

[Marcin4111]

Thanks Karedog
Actually the code is simpler, but picture is not scaled to full width of merged cells.
I wonder about center and middle allign to full width for the graph. Do you perhaps know how to modify code?

Please Login or Register  to view this content.

[karedog]

Is this a picture or a graph ? You can't use your macro above for graphs.
Please upload a sample file to clarify it.

[Marcin4111]

So here you can find button Upload Picture. When clicked, you run two macros:
- Insert Picture, and
- Position and Scale Picture
^{20141117 generator procesów.xlsm}

[karedog]

I find that the code at post #3 already fulfill your wish, that is "full width of merged cells ", of course since this code is keeping the aspect ratio (the pic will not distort), the height of pic will vary, either smaller or bigger than cell height. Here is the sample pic : Keep aspect ratio

But if you want the whole cell is covered with the pic (this mean sacrifice the "keep aspect ratio"), then this is the code :

Please Login or Register  to view this content.

The sample pic : Full - distorted

[Marcin4111]

Thank you,
It works great for height. However, is it possible to fit picture in frames of merged cells with aspect ratio excluded?
wizualizacja.jpg

[karedog]

Your picture is not showed up, I get an error : "The image http://www.excelforum.com/attachment...zualizacja.jpg cannot be displayed because it contains errors."

BTW, the code at post #6 already "exclude aspect ratio".

[Marcin4111]

What I mean is auto-fit to right of merged cells - http://www.opendrive.com/files/OF81O...zualizacja.jpg

[karedog]

I just realize that for Excel 2007++ the aspect ratio is default to locked (previously I tried to run using Excel 2003, and its default is not to locked).
Here is the code to disable aspect ratio :

Please Login or Register  to view this content.

[Marcin4111]

Works perfect!
Thank you for your help and time.

Regards,
Marcin Krawczynski

[karedog]

You are welcome Marcin, and please mark this thread as SOLVED, thank you.