BottomRightCell Property Example
This example displays the address of the cell beneath the lower-right corner of embedded chart one on Sheet1.
MsgBox "The bottom right corner is over cell " & _
Worksheets("Sheet1").ChartObjects(1).BottomRightCell.Address