Chart how to find lastrow?

I am creating charts on a seperate worksheet and need to locate the bottom of the last chart on the page.

I have code that pops charts into columns b thought m. I am creating each chart under the one above it. I need to locate the botom of the previously created chart to determine where the next chart should begin.

The grey cells are failiing me again!

Thanks for your help!

Craig

Dim objCht as ChartObject
with Activesheet.
set objCht = .ChartObjects(.ChartObjects.count)
End with

msgbox objCht.bottomRightCell.Row

--
Regards,
Tom Ogilvy


"Craigm" wrote:

>
> I am creating charts on a seperate worksheet and need to locate the
> bottom of the last chart on the page.
>
> I have code that pops charts into columns b thought m. I am creating
> each chart under the one above it. I need to locate the botom of the
> previously created chart to determine where the next chart should
> begin.
>
> The grey cells are failiing me again!
>
> Thanks for your help!
>
> Craig
>
>
> --
> Craigm
> ------------------------------------------------------------------------
> Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
> View this thread: http://www.excelforum.com/showthread...hreadid=530492
>
>

Dim objCht as ChartObject
with Activesheet.
set objCht = .ChartObjects(.ChartObjects.count)
End with

msgbox objCht.bottomRightCell.Row

--
Regards,
Tom Ogilvy


"Craigm" wrote:

>
> I am creating charts on a seperate worksheet and need to locate the
> bottom of the last chart on the page.
>
> I have code that pops charts into columns b thought m. I am creating
> each chart under the one above it. I need to locate the botom of the
> previously created chart to determine where the next chart should
> begin.
>
> The grey cells are failiing me again!
>
> Thanks for your help!
>
> Craig
>
>
> --
> Craigm
> ------------------------------------------------------------------------
> Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
> View this thread: http://www.excelforum.com/showthread...hreadid=530492
>
>

Just what I needed.

Thanks