Chart how to find lastrow?
 

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

--
Craig
-----------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...fo&userid=2438
View this thread: http://www.excelforum.com/showthread.php?threadid=53049

Chart how to find lastrow?
 

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

Chart how to find lastrow?
 

Just what I needed.

Thanks


--
Craigm
------------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=530492