Fit picture to cell

**shiftyspina** · 10-04-2013, 05:23 AM

Hi

I am using a dynamic range to determine what picture to put into a cell, and have used a macro to try and fit the picture to the cell which is

Please Login or Register  to view this content.

BEFORE I GET A WARNING, THE POST WONT LET ME PUT CODE TAGS OR FORMULA TAGS AROUND THE TEXT???????

but this doesnt work? my cell has =ShowMyPic in it

Which is picking up the linked cell from a combo box

Is there a way i can get the picture to autofit the cell?

**alansidman** · 10-04-2013, 05:26 AM

Not sure about your comment on code tags. I added them for you since you commented about them. No warning this time.

**ragulduy** · 10-04-2013, 05:37 AM

Please Login or Register  to view this content.

with regards to code tags, the toolbar for posting isn't appearing so you need to type CODE and /CODE in square brackets before and after the code.

**shiftyspina** · 10-04-2013, 05:48 AM

Ok thank you both, i will give that a go cheers

Fit picture to cell

LinkBack

Thread Tools

Rate This Thread

Display

Fit picture to cell

Re: Fit picture to cell

Re: Fit picture to cell

Re: Fit picture to cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] sizing picture same picture in multiple sheets macro clean up

VBA for Picture insert at particular worksheet range. Picture name derived from cell.

Creating macro to insert a picture by including specific picture name & path

[SOLVED] macro: insert picture based on workbook location, not picture root path.

Insertion of picture by xls formula/ naming the picture with multiple selection crite

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions