I think I just figured this out. Stumbled across a link on another page which then lead to another link, then the answer
Looks like I need to use the following if I do not know the name of the Shape:
This way, it will always take the first shape it comes into contact with and it doesn't matter if the name changes.Code:ActiveSheet.Shapes(1).Select
FYI to anyone else who needs to figure this out. Hope this helps.





Reply With Quote