Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shape Range | Charts and Charting in Excel | |||
detecting range of spreadsheet | New Users to Excel | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
align a picture/shape in a Range! | Excel Programming | |||
detecting shape clicked on | Excel Programming |