We often have a large number of photos with associated meta data that need to be sorted, edited, and eventually exported to a PDF in order to create a photolog. I had sliced together a macro that automatically imports a selection of photos into excel and allows them to still be sorted or moved with the cell. The problem is that anytime they are printed or exported to a PDF, is that every page has a tiny sliver of the first photo from the next page at the bottom. It seems that excel is including the sliver because it is too close to the border, so when it uses that cell border to finish off the bottom of the page its pulling part of the picture with it? I have tried adding thick borders to the pictures and adding thick boarders to the cells to try to push the picture sliver down to its correct page. In instances where we have over 200 photos it is not feasible to resize every photo manually, and in the past changing certain photo attributes by hand has resulted in them not sorting with their cell.
I have included a zipped example workbook and two sample photos as attachments for ease. It cut me off at two photos and for whatever reason the system refused to accept a zipped folder that contained more than one file so they are all individually packaged.
Capture.PNG
Bookmarks