How can I print a worksheet excluding blank rows?
 

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?

How can I print a worksheet excluding blank rows?
 

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

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

lohme wrote:
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

Thanks, Don, I'll give this a try.

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

Thanks. I'll give this a try.

"Pete_UK" wrote:

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

lohme wrote:
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

That worked like a treat!!! Thanks so much.

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

glad to help

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
That worked like a treat!!! Thanks so much.

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

try
columns(1).rows.hidden=false
--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

I would suggest this (based on Don's hideem):

Sub show_em()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False
End Sub

Hope this helps.

Pete

lohme wrote:
Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

Thanks - you and Don were a huge help!

"Pete_UK" wrote:

I would suggest this (based on Don's hideem):

Sub show_em()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False
End Sub

Hope this helps.

Pete

lohme wrote:
Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?

How can I print a worksheet excluding blank rows?
 

glad to help

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
Thanks - you and Don were a huge help!

"Pete_UK" wrote:

I would suggest this (based on Don's hideem):

Sub show_em()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = False
End Sub

Hope this helps.

Pete

lohme wrote:
Don, what is the command to unhide the rows? unhideem?

"Don Guillett" wrote:

to hide rows with blanks in col A

Sub hideem()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRo w.Hidden = True
End Sub

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
I want to automate the printing and I won't know how many blank rows
I'm
going to end up with each time.

"Don Guillett" wrote:

hide em

--
Don Guillett
SalesAid Software

"lohme" wrote in message
...
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?