hi all...
i need help how to extract picture then automatically placing and resize onto box..
start box in row 84 to 87..
please, check this file..
any help, much appreciated...
john m
hi all...
i need help how to extract picture then automatically placing and resize onto box..
start box in row 84 to 87..
please, check this file..
any help, much appreciated...
john m
i think this new file make clear...
i have extract/insert picture 4 pic from a folder in cell
then i want 4 pic can automatically resize and placed in cell star row from 84 to 87 (4 box cell)
my arrow i hope can be explain..
how to make it using vba/macro
This will work for you example. But to make it more generally useful you may need a better way of identify the pictures to be moved.Please Login or Register to view this content.
hi andy...
after i change that picture with the new picture in different cell..
that code not work...
showing system error - the parameter is incorrect....how to code keep running wherever that picture place
how to fixed?
note :
i pull picture from excel Menu Insert, Picture browse picture...
Last edited by Jhon Mustofa; 09-30-2017 at 12:35 PM.
As I said you need a more positive way to identify the pictures to be used.
You might be able to use the picture collection and ignore the existing pictures used for logos at the top of the sheet.
Perhaps a better way would be to load pictures on to a spare sheet firstPlease Login or Register to view this content.
Please Login or Register to view this content.
thank you very much Andy...it's help me..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks