Printout Question

[LenaH]

Dear all,

I have several list, that I need to print out. The lists are filled from top to bottom.
So it happens, that I have lists that only fill 1 page, but still printout the whole 6 pages.

What a waste of paper!

Is there a way to have Excel determine the amount of data, the lists are filled with and
only printout the necessary ones?

Oh and if possible, that needs to be done with VBA code, since automated.

This is the general code, to print the lists:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False

Lena

 

[JLGWhiz]

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False

jjust add in the From and To parameters as shown above to tell it which pages to print.

 

[LenaH]

The filling of this table is dynamic. It can be 6 pages or less. Setting it to one page doesn't do the trick, unfortunately.

 

[GWteB]

From my understanding you are looking for a way to manage the print area. Some questions need to be answered.
- how many lists / tables are there on each worksheet to print?
- which columns are used to populate / display / print each list?
- are there headers / footers / title rows involved?
- which column can be used to determine the bottom of each list?
You might consider to provide a sample of your list(s).