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!
the chartobject has a .topleftcell and a .bottomrightcell property which shoukd give either of the rows in which you are interested
hope this helps
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)
EDIT: Yeah it's this scaling that's stopping them from working. If I leave it at 100% the breaks start working again. However, then I have a problem that my sheet is 50% to large, and requires a double-width paper to print. Any ideas how to get around this?
Last edited by F*SH; 07-19-2006 at 07:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks