VBA - Auto Resize Cell & Row Height then Resize Pictures to fit

[Quinnc1991]

Hi guys,

I'm currently using a VBA attached to a button to pull images through from an external source but I want to set up a separate button which resizes the row and column width/ height to 25 and then auto sizes the all images (which are in Row D) to the new row and column/ width.

Thanks so much in advance!

 

[Learn Excel in Tamil]

Hi

Try this code

Columns(4).Select
Selection.ColumnWidth = 35
Selection.RowHeight = 35
ActiveSheet.Shapes.Range(Array("Picture 2")).Select
Selection.ShapeRange.Height = 40.8
Selection.ShapeRange.Width = 150.8

Thanks and Regards,
Learn Excel in Tamil