How can I print a worksheet excluding blank rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to print a worksheet where their are blank rows for future use between
the main body of the data and the total row. I want to exclude the blank
rows. How can I do this?
 
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.
 
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.
 
You can apply a filter on a column which includes a total (or some text
like "Totals:"), selecting non-blanks. If by "automate the printing"
you mean use a macro, then you can incorporate the necessary code to
filter out the blanks before printing and to reset them afterwards.

Hope this helps.

Pete
 
You can apply a filter on a column which includes a total (or some text
like "Totals:"), selecting non-blanks. If by "automate the printing"
you mean use a macro, then you can incorporate the necessary code to
filter out the blanks before printing and to reset them afterwards.

Hope this helps.

Pete
 
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
 
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
 
Thanks, Don, I'll give this a try.

Don Guillett said:
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Click to expand...
 
Thanks. I'll give this a try.

Pete_UK said:
You can apply a filter on a column which includes a total (or some text
like "Totals:"), selecting non-blanks. If by "automate the printing"
you mean use a macro, then you can incorporate the necessary code to
filter out the blanks before printing and to reset them afterwards.

Hope this helps.

Pete
Click to expand...
 
Thanks, Don, I'll give this a try.

Don Guillett said:
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Click to expand...
 
Thanks. I'll give this a try.

Pete_UK said:
You can apply a filter on a column which includes a total (or some text
like "Totals:"), selecting non-blanks. If by "automate the printing"
you mean use a macro, then you can incorporate the necessary code to
filter out the blanks before printing and to reset them afterwards.

Hope this helps.

Pete
Click to expand...
 
That worked like a treat!!! Thanks so much.

Don Guillett said:
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Click to expand...
 
That worked like a treat!!! Thanks so much.

Don Guillett said:
to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
End Sub
Click to expand...
 
Back
Top