NOT PRINTING CONSECUTIVE BLANK ROWS

[philipjsmith]

I have a worksheet that includes some empty rows which are located at random intervals throughout the page. I would like the Print command to ignore all consecutive rows of 2 or more, i.e. NOT to print two or more blank rows. Is there a way of incorporating a suitable macro in the general Print command that will do this, or if not can a separate macro be made to make an allowance for this before the Print command is clicked?

 

[Eric B]

Filter-based answer. Sorry I don't have a macro that could help. Until someone does, maybe this will help. Make a new column adjacent to the print range and enter the following in the second row and copy down as needed:
=ISBLANK(A1)+ISBLANK(A2)
Then turn on the autofilter
Data|Filter|Autofilter
From the drop down menu on the new column, pick Custom|does not equal| and enter the value "2".
This should kill the second of the double blank rows. Again, sorry if that was too basic for what you were after.

HTH
-Eric

 

[Eric B]

Filter-based answer. Sorry I don't have a macro that could help. Until someone does, maybe this will help. Make a new column adjacent to the print range and enter the following in the second row and copy down
=ISBLANK(A1)+ISBLANK(A2)
Then go to Data|Filter|Autofilter
From the drop down menu on the new column, pick Custom|does not equal| and enter the value "2".
This should kill the second of the double blank rows. Again, sorry if that was too basic for what you were after.

HTH
-Eric

 

[philipjsmith]

Thanks but how do you prevent the new column from being printed out?
Do you have to re-set the print area?
If so, this would defeat the object of the exercise.
Thanks again.