GS wrote:
* Page breaks will not show in a chart because a chart is "in front" or
overlays cells.
PageBreaks don't show at all; - they reside in the cell where they are
inserted!
** Furthermore, a chart can take a rather large number of cells (C6..Q38).
** Again, what code is needed to print a chart?
Again, you can't print a chart (or any other object) apart from its
position on the worksheet. *Excel only prints sheet contents in their
respective location on a sheet*
* Not true; easy and simple when done manually:
1) Select the chart
2) File-- Print
Done.
Wrong in the context you requested; - you can NOT duplicate that in VBA
otherwise you'd be able to create code via the Macro Recorder!
Using VBA, since that is the context of this thread, you must specify the range
the chart resides in to include it in a printout. Ergo, why I use PageBreak at
each insertion cell to get one object (chart,picture,shape) printed per page.
(Assumes all objects are within defined Print_Area)
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion