Chart how to find lastrow?

[Craigm]

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

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

The grey cells are failiing me again!

Thanks for your help!

Crai

 

[Guest]

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

msgbox objCht.bottomRightCell.Row

 

[Craigm]

Just what I needed.

Thanks