Resize a picture

[nguyennb]

I want to insert a picture on a cell of Excel. But this cell is too small. How do I shrink picture for a cell (use VBA)

[Mat_Davies]

You can use the following code

Please Login or Register  to view this content.

You'll need to know the name of the shape (they're numbered sequentially as they're inserted in to the sheet). The exact numbers you need to make it fit in (over) a cell may depend on your computer so try altering them. I can't find a way to insert the picture in to the cell (using something akin to the 'in line with text' option in word) but there may be a way...

Cheers

Mat

[Andy Pope]

You can only position the picture over a cell rather than in it.
Shapes float on a drawing layer above cells.

This will use the dimensions of the cell to size the shape to.

Please Login or Register  to view this content.