Ok so first up, I have spent an hour browsing around the forums for VBA code to do this for me, and can't get it to work... 
I have to create about 300 pictures within cells, and would really like to be able to do this based on cell values (inserting 300 pictures is going to take forever!!!). It would also be handy to know how to do this, because I will have to do it again in the near future.
The file is currently held at http://www.filedropper.com/bolttestfile
As you can see, there are 15 file names based within cells A4:A18. In B74 is a test picture, and I need the range B74:B78 to be filled with the pictures from A4:A8. Seems simple enough, but I can't figure it out
.
If you need to ask any other questions, please feel free. I don't need this whole thing done for me, just some code that I can understand and start manipulating (new to this VB excel stuff)
Cheers
I have to create about 300 pictures within cells, and would really like to be able to do this based on cell values (inserting 300 pictures is going to take forever!!!). It would also be handy to know how to do this, because I will have to do it again in the near future.
The file is currently held at http://www.filedropper.com/bolttestfile
As you can see, there are 15 file names based within cells A4:A18. In B74 is a test picture, and I need the range B74:B78 to be filled with the pictures from A4:A8. Seems simple enough, but I can't figure it out
.If you need to ask any other questions, please feel free. I don't need this whole thing done for me, just some code that I can understand and start manipulating (new to this VB excel stuff)
Cheers
