Hi,
The RangeFromPoint method cannot be used on a chartsheet to get the Shape
below given coordinates.
For example, the following code with return the name of the rectangle, if
you draw a rectangle at the top-left corner of a worksheet, but it will
generate a bug for a chart sheet:
Public Sub MyName()
Dim ObjShape As Object
Set ObjShape = ActiveWindow.RangeFromPoint(x:=200, y:=200)
If Not ObjShape Is Nothing Then
MsgBox ObjShape.Name
End If
End Sub
Is there something equivalent for chartsheets?
If not, it would be great that RangeFromPoint is available on Chartsheets.
Regards,
Mr T
Bookmarks