Picture Index issue.

[atomichybrid]

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.

Please Login or Register  to view this content.

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