macro print non-empty cells

[max_max]

Hello in the attached workbook there is a macro that selects only the non-empty cells and then prints the various sheets.
Now only a certain number of cells are active and 3 sheets are printed with the print titles in the 3 sheets.
I request a chang:
you have to print in addition to the active sheets (non-empty cells), a last sheet with the yellow cells of the range A207: L2017 without printing titles like the previous sheets.
I hope I explained myself.
A greeting.
max

[Keebellah]

Hi, Ciao,
A question. the Yellow area, will that always be the same size? Rows 207 -217?
The table above will then always end at row 206?
Is this correct?
My first suggestion is to change the range A5-L206 to a table, that way you can apply the filter without having influence on the yellow section below.
Define two Print areas, one form A1-L206 for the three pages with the headers and on of the yellow section A207-L217, then all you have to do is set the filter in the first column to non blanks and print the first part and the set the print area to the yellow part and print that area.
I'll try to implement it with the sample file you attached, but this is the idea.

[Keebellah]

Here is my way of doing it, if you press STAMPA now you'll have to print it to see the result. Preview will not work correctly

[max_max]

Hi keebeelah,
I tried but there is a 438 error with the line:

Application.PrintCommunication = False

I have excel 2007 and this does not work.
I found a solution on the net:

On Error Resume Next
Application.PrintCommunication = False
Err.Clear

Please Login or Register  to view this content.

everything works now.
The macro is perfect.
Greetings and thank you very much.
max

[Keebellah]

That does happen sometimes and maybe it is a 2007 issue
But, does your addition work?

[max_max]

Yes, it works

[Keebellah]

And THAT is what it should do
Glad to hear.
The error you mention is sometimes also related to the current active printer (driver) which does not communicate with Windows and then you can also get the same error