I have a worksheet that has several "Pictures" or, Picture objects, on it that I would like to remove.
In running the Macro Recorder, it lists these objects as ActiveSheet.Shapes("Pictur
e #") or
In putting together some code to delete these I used - This is the short version to my question:
Dim shp As Shape, i As integer
i = 1
For Each shp In ActiveSheet.Shapes
i = i + 1
i = 0
That doesn't work though, it doesn't recognize the "i". However, If I replace the i with a 1, then it will work. I have tried changing i to Long, String, etc. Even though i = 1 is the right value, the code won't allow it to excecute, it has to be the actual number. Why is this? It defeats the whole purpose for variables.