Finding the cell in which an object lies
 

Hi again

I'm trying to make a page break after a chart. But I can't do this it
seems, the page break can only be inserted into a cell/row.

Any idea how to determine the cell that the corner of an object is in?
I want to take my object, find what call it is above, and break based
on that cell.

Cheers!


--
F*SH
------------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...o&userid=36355
View this thread: http://www.excelforum.com/showthread...hreadid=562511

Finding the cell in which an object lies
 

the chartobject has a .topleftcell and a .bottomrightcell property which
shoukd give either of the rows in which you are interested

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=562511

Finding the cell in which an object lies
 

Bingo, that's exactly what I was looking for. Works a charm - thanks!

But unfortunately my pagebreaks don't. Although I've inserted them OK,
both print preview and actual printoffs completely disregard the
inserted breaks - why might this be? I've got a frozen pane at the top
of my sheet, and also I've set the print options to scale down to 66%
(to get the page fitting on only one sheet horizontally)


--
F*SH
------------------------------------------------------------------------
F*SH's Profile: http://www.excelforum.com/member.php...o&userid=36355
View this thread: http://www.excelforum.com/showthread...hreadid=562511