print non-empty cells

[max_max]

Hello to all
in the attached workbook there are many empty columns.
Is it possible to print only non-empty columns?
Now from example attached should print columns only A:U and AP:AQ
Of course it is not always as in the example but the non-empty columns can be more or less
thanks you
max

[KOKOSEK]

Put into standard module:

Please Login or Register  to view this content.

and into ThisWorkbook code:

Please Login or Register  to view this content.

should works.

[max_max]

Hi
It is not always as in the example but the non-empty columns can be more or less
the macro should do everything automatically
print button> hide empty columns

[KOKOSEK]

Change this:

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

and should works. Hide column before print and unhide after. Automatically.

[max_max]

Hi kokosek
your macro works if there are no formulas in the cells
Unfortunately where I insert your macros in all cells there are formulas
Only in the visible cells there is a result in the others there is no result
Now with your macros no columns are hidden

[KOKOSEK]

You send example with empty column and these columns are hidden.
Send more proper attachment. We can't suspect that some of these column can be filled by formulas as there is any formula there.

[max_max]

here is example
In the "tagli" sheet there is a button linked to the macro

[KOKOSEK]

Try:

Please Login or Register  to view this content.

[max_max]

Hi kokosek
the new macro work well.
How to change why not print the column BB?

[KOKOSEK]

How to change why not print the column BB?

Sorry I do not understand. Do you want to hide BB or not?

BTW: I've left unnecessary data in row 1, which have to be delete in last attachment. And change code here:

Please Login or Register  to view this content.

[max_max]

Hi kokosek
I have adjusted the page breaks
Now pages 4/5/6 are blank, you can not print them?
Of course if there were values you have to print them.

[KOKOSEK]

Pages 4/5/6 won't be printed when there is nothing to print on them.
That's how it looks like 'prepare for printing' (after hideColumns)

[max_max]

Print 4/5/9 blank pages

[KOKOSEK]

Check attached file.

[max_max]

Print 4/5/6 blank pages

[KOKOSEK]

That's probably something with your excel/printer setting as there are not.

[max_max]

Ok kokosek
thanks for everything
max

[max_max]

Hello again
in the attached workbook the printing is now regulated in horizontal priority
Is it possible that I print the sheet 1/3/5 together with column BB as per attached photo
without adjusting the page breaks every time?

[max_max]

Maybe I explained myself wrong?
It should work like this:

now the page breaks are

page 1 = D3: AA3
page 2 = AA3: BB3

page 3 = D42: AA42
page 4 = AA42: BB42

page 5 = D82: AA82
page 6 = AA82: BB82

if the non-empty cells are within the range D3:AA3 / D42:AA42 / D82:AA82 add column BB to the printout

if non-blank cells are larger than normal print

max

[KOKOSEK]

I do not really know what kind of problems you are struggling with...
Before - all columns, then empty columns hidden + still printable BB column.

[max_max]

In the attached workbook there are 6 pages to print.
The page order is in horizontal priority.
Not all cells are non-empty.
I ask if it is possible to add a column to the printout in this manner

Now the page breaks are

page 1 = C3: AC3
page 2 = AD3: BB3

page 3 = C43: AD43
page 4 = AC43: BB43

page 5 = C82: AC82
page 6 = AD82: BB82

if the non-empty cells are within the range C3: AC3 / C43: AD43 / C82: AC82 add column BB to the printout (esempio1)

if the non-empty cells are higher than the range C3: AC3 / C43: AD43 / C82: AC82 and therefore are also
in the range AD3: BB3 / AC43: BB43 / AD82: BB82 normal printing (esempio2)

see example1 / example2 in the attached example