Assigning PRINT AREAS and no. of PAGES to PRINT

  • Thread starter Thread starter Billabong
  • Start date Start date
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
 
Seems straightforward enough. Have a single sheet unit of 6 charts, s
you can calculate the number of pages required etc. from that ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel print area which only prints pages of worksheet which are active 0
Can "print area" cover entire page??? 6
Dynamic Print Area 2
Macro for Print Area 1
Userform to Select what worksheets to print 1
Print entire workbook with each sheet starting at page 1 8
Print area problem 1
Find print area when no print area set 3

Back
Top