如何使用VBA在Excel中获取一个形状的BottomRightCell/TopLeftCell ?

I have grouped a few shapes into a group. Let's call it Group1. I want to get the BottomRightCell/TopLeftCell of a particular shape, Shape1, in Group1. But whenever I run this code:I have grouped a few shapes into a group. Let's