Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
resetting last cell | Excel Discussion (Misc queries) | |||
unknown object in cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |