Good day all,
I have a question for you. When I do an insert screenshot command in Excel 2010 it names the picture as follows:
ActiveSheet.Shapes.Range(Array("Picture 1"))
If I delete that picture and do another insert screenshot command it names the picture as follows:
ActiveSheet.Shapes.Range(Array("Picture 2"))
What I need to do is reset that array back to "Picture 1" every time my macro goes through and deletes the array of pictures. In other words, if I insert 3 pictures and then delete them I want the next picture inserted to be "Picture 1" and not "Picture 4".
Is there a simple way to do this? I know little to nothing about arrays and would be grateful for your help.
Thank you all for your help!
JDeiley
I have a question for you. When I do an insert screenshot command in Excel 2010 it names the picture as follows:
ActiveSheet.Shapes.Range(Array("Picture 1"))
If I delete that picture and do another insert screenshot command it names the picture as follows:
ActiveSheet.Shapes.Range(Array("Picture 2"))
What I need to do is reset that array back to "Picture 1" every time my macro goes through and deletes the array of pictures. In other words, if I insert 3 pictures and then delete them I want the next picture inserted to be "Picture 1" and not "Picture 4".
Is there a simple way to do this? I know little to nothing about arrays and would be grateful for your help.
Thank you all for your help!
JDeiley