Paul wrote:
Robert Baer wrote:
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.

https://docs.microsoft.com/en-us/off...mbedded-charts


** Paul
No charts found; cannot work as-is.
If i change the word chart to shape i can find 16 shapes, which is
correct; it is the 4th shape, but one the activate crashes.
Then there is the problem of assigning a name to the print file.
Noodling around on that site was worse than not trying.
Tying the baby bird Goo-Gull,got nowhere.

Once upon a time, in one version of Excel,this worked:
ActivePrinter:="Acrobat PDFWriter", PrintToFile:= True, PrintToFile:=
True, _
PrintOut Copies:= 1, Preview:= False, Collate:= False, _
PrToFilename:=pPath + vNam + ".PDF"

Excel barfs.
Also, i was able to derive the above sequentially, comma to comma or
entry to entry from a pulldown in Excel - i think in edit.

No more; NO help even for ActivePrinter, were i started (i think).

Thanks.