Excel VBA: Capturing a cell in a range variable
===

Anyone see what is wrong with this code. I'm getting an 'object required' error:

    Dim r As Range
    Set r = Sheet2.ChartObjects("myChart").BottomRightCell.Address

Seems pretty straightforward, but it won't work. I need to on to be able to do:

r.row and r.column

Thanks! 