Marco to Insert Objects onto spreadsheet without them overlapping eachother

  • I want to put 30+ .jpg pictures into a spreadsheet. I have them all in one folder too. I want to have a column of the objects, so that you just have to double click on one to view it.


    Using Insert > Object > Create from File makes it easy to do one jpg at a time, but I hoping to use a macro to make it easier. I googled it, and came across a pretty nice solution here and here using the same macro, but the macro has a problem where the objects are all on top of one another.


    This picture is pretty much what I want the spreadsheet to look like, only with jpg instead of txt files


    [ATTACH=CONFIG]67973[/ATTACH]

  • Re: Marco to Insert Objects onto spreadsheet without them overlapping eachother


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!