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.Add ress

Seems pretty straightforward, but it won't work.

Thanks!