I have several pictures in a spreadsheet that I want to paste into another worksheet. Then I want to run a macro to place those pictures into the exact postions I want them in everytime I do this.
The pictures are named "Picture 1, Picture 2, and Picture 3". I discovered that when I paste the pictures into the second document, the pictures are renamed "Picture 4, Picture 5, and Picture 6". If I paste them a second time they are then named "Picture 7, Picture 8, and Picture 9". I will never paste them twice, I just noticed that excel looks at how many pictures are present and increments the name by one.
My macro that I want to create will never work if it is searching for "Picture 1" and it isn't there.
My question is - Is there any way to reset the picture count or have the pictures start at the name "Picture 1" each time I open the file?
Thanks in advance!
The pictures are named "Picture 1, Picture 2, and Picture 3". I discovered that when I paste the pictures into the second document, the pictures are renamed "Picture 4, Picture 5, and Picture 6". If I paste them a second time they are then named "Picture 7, Picture 8, and Picture 9". I will never paste them twice, I just noticed that excel looks at how many pictures are present and increments the name by one.
My macro that I want to create will never work if it is searching for "Picture 1" and it isn't there.
My question is - Is there any way to reset the picture count or have the pictures start at the name "Picture 1" each time I open the file?
Thanks in advance!