Hi guys,
I have a working sheet that can resize my images to the cell size.
As of late some pictures need to change and I have a problem. An example for this is shown below.
Picture 1
Picture 2
Picture 3
Picture 4
Picture 5
Picture 6
Suppose I delete Picture 2 and replace it with a new image. The problem is the new image inserted will be called Picture 6 and Picture 3-6 will be renamed as Picture 2-5 when I run this macro.
Here is the macro used for the image resize.
Is there a way to reset the picture index name in order and not in order of when it was last inserted (if you know what I mean).
EDIT: Also I forgot to mention the pictures shift up which will make the entire table wrong. So I thought if the naming index is fixed then the shifting would stop too.
Cheers
Bookmarks