Assigning PRINT AREAS and no. of PAGES to PRINT

B

Billabong

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
Click to expand...
determine the number of pages to PRINT on a A4 size paper using VBA?

More power!!!

Billabon
 
B

BrianB

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