the function ExportAsFixedFormat xlTypePDF does not print images, charts or graphs.
Dim sPath As String
sPath = "/path/to/myreport.pdf"
Sheet1.ExportAsFixedFormat xlTypePDF, sPath
will produce a PDF file, but if the print range contains images ,graphs, etc. they will be omitted.
Thanks for reporting this issue. The fix for this will be in the next update (v16.13), which should be released in mid-May.
Kevin Brown commented
This bug has the potential to greatly negatively impact the value of this product to me. Please fix this ASAP. thanks.
please fix this bug. Mac users need to use excel too! This is a huge problem.
Please fix this. It would be beneficial to allow images to print. Really messes up work flow.
Essie Djafarian commented
Please fix this bug, it is essential for being able to PDF in order to save on paper and get a proper work flow
Thanks a lot
I forgot to mention that we are seeing this in 16.11.1 but have been aware of this issue for a few months now.