Detecting if a range contains a shape
As the topic title says, I'm trying to determine whether a range of
cells contains a shape. So far, I can see only one method:
Iterate through all the shapes in the worksheet and do boundary
checking using the TopLeftCell and BottomRightCell properties of the
Shape object.
This works but there could be 100's of shapes to iterate through on the
worksheet that I'm working with, so it would be computationally
expensive.
Is there a way to take a Range object and test it directly to see if it
contains any Shapes?
|