ExcelBanter - Assigning PRINT AREAS and no. of PAGES to PRINT

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Assigning PRINT AREAS and no. of PAGES to PRINT (https://www.excelbanter.com/excel-programming/307820-assigning-print-areas-no-pages-print.html)

Billabong

Assigning PRINT AREAS and no. of PAGES to PRINT

Hi to every excel enthusiast,

This is the scenario:

CHARTS are created and pasted on a single sheet that looks like
report manager.
No. of objects pasted in (CHARTS) ranges from 1 to 18.
6 CHARTS is enough for a SINGLE PAGE to PRINT.
PROBLEM: Determine how to automatically set-up PRINT AREAS an
determine the number of pages to PRINT on a A4 size paper using VBA?

More power!!!

Billabon

--
Message posted from http://www.ExcelForum.com

BrianB

Assigning PRINT AREAS and no. of PAGES to PRINT

Seems straightforward enough. Have a single sheet unit of 6 charts, s
you can calculate the number of pages required etc. from that ?

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 04:49 AM.