Hi all,

Is there a way to determine the last row where a chart object finishes
As I am trying to set a dynamic printing area and my chart change
height dependant on the data criteria.

TI

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=52476

set rng = activesheet.ChartObjects(1).BottomRightCell
msgbox rng.row

--
Regards,
Tom Ogilvy



"gti_jobert" wrote:


Hi all,

Is there a way to determine the last row where a chart object finishes?
As I am trying to set a dynamic printing area and my chart changes
height dependant on the data criteria.

TIA


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=524768

Thanks Tom........works perfectly

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=52476