How to prevent "printing" empty pages?

[MariaPap]

Hello

I use this code to Print a report in sheet "C14PR" starting from E1 until last row with values and last column with data which is column O.

Please Login or Register  to view this content.

The problem is that in Column O-starting in O6,until O200, i have a formula that gives me "empty" cells under conditions.

So macro, prints ALL the pages until O200, most of these emties of course!

How can i modify the code to print only pages with data?

Thanks in advance for any assistance on this!

[Fotis1991]

Maria hoping that you have at least one column(i used column F(6)) in your range that has no empty cells until the last used,try this.

Please Login or Register  to view this content.

What actually this code does? Hides all the empties rows before print and after print, appears all rows again.

[ragulduy]

@Fotis, I think .specialcells(xlcelltypeblanks) will not return cells which contain a formula that has a blank result, only cells containing no value/text/formula, so not sure that would work.

You probably need to use:

Please Login or Register  to view this content.

instead.

[MariaPap]

Thank you Mr Foti.

Works great as all your suggestions.

Actually i have 2 columns with all rows filled with data. 7 &10. I choosed 7!!

yudlugar

Thank you for the suggestion. Can you provide the full code just for try to learn?, because as i said, Mr Fotis code, do exactly what i need.