Determing Last Row

[gti_jobert]

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

[Tom Ogilvy]

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
>
>

[gti_jobert]

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