Capturing BottomRightCell in a Variable

  • Thread starter Thread starter usr58201
  • Start date Start date
U

usr58201

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.

Thanks!
 
usr58201 said:
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.
Click to expand...

..Address is a string, not a range (or any other type of object that requires
"Set"). Either do this:
Dim r As Range
Set r = Sheet2.ChartObjects("myChart").BottomRightCell

....or this:
Dim r As String
r = Sheet2.ChartObjects("myChart").BottomRightCell.Address
 
Back
Top