Posts1Registration dateFriday February 9, 2018StatusMemberLast seenFebruary 9, 2018
Feb 9, 2018 at 03:58 AM
Posts2921Registration dateSunday September 12, 2010StatusModeratorLast seenJanuary 16, 2023
Feb 15, 2018 at 11:40 AM
Respected CCM team members,
I am trying to insert images from a folder into excel by matching file names specified in a column, everything is running fine but facing issue of row & column resizing according to image size.
It would be very helpful if anyone can guide to edit the below mentioned macro, so that the column & row gets resized automatic.
Thanks in Advance.
Macro mentioned below..
Private Sub CommandButton1_Click()
Dim pictureNameColumn As String
Dim picturePasteColumn As String
Dim pictureName As String
Dim lastPictureRow As Long
Dim pictureRow As Long
Dim pathForPicture As String