How can I print a worksheet excluding blank rows?

[lohme]

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?

[Don Guillett]

hide em

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"lohme" <lohme@discussions.microsoft.com> wrote in message
news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
>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?

[lohme]

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
> dguillett1@austin.rr.com
> "lohme" <lohme@discussions.microsoft.com> wrote in message
> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> >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?
>
>
>

[Don Guillett]

to hide rows with blanks in col A

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"lohme" <lohme@discussions.microsoft.com> wrote in message
news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
>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
>> dguillett1@austin.rr.com
>> "lohme" <lohme@discussions.microsoft.com> wrote in message
>> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
>> >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?
>>
>>
>>

[lohme]

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).EntireRow.Hidden = True
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "lohme" <lohme@discussions.microsoft.com> wrote in message
> news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
> >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
> >> dguillett1@austin.rr.com
> >> "lohme" <lohme@discussions.microsoft.com> wrote in message
> >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> >> >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?
> >>
> >>
> >>
>
>
>

[lohme]

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).EntireRow.Hidden = True
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "lohme" <lohme@discussions.microsoft.com> wrote in message
> news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
> >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
> >> dguillett1@austin.rr.com
> >> "lohme" <lohme@discussions.microsoft.com> wrote in message
> >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> >> >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?
> >>
> >>
> >>
>
>
>

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"lohme" <lohme@discussions.microsoft.com> wrote in message
news:26419E7E-D599-4C0A-8C7D-6DB4EF273A80@microsoft.com...
> 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).EntireRow.Hidden = True
>> End Sub
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "lohme" <lohme@discussions.microsoft.com> wrote in message
>> news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
>> >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
>> >> dguillett1@austin.rr.com
>> >> "lohme" <lohme@discussions.microsoft.com> wrote in message
>> >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
>> >> >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?
>> >>
>> >>
>> >>
>>
>>
>>

[lohme]

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).EntireRow.Hidden = True
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "lohme" <lohme@discussions.microsoft.com> wrote in message
> news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
> >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
> >> dguillett1@austin.rr.com
> >> "lohme" <lohme@discussions.microsoft.com> wrote in message
> >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> >> >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?
> >>
> >>
> >>
>
>
>

[Don Guillett]

try
columns(1).rows.hidden=false
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"lohme" <lohme@discussions.microsoft.com> wrote in message
news:96510508-54EE-402D-9351-62B861ED32AA@microsoft.com...
> 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).EntireRow.Hidden = True
>> End Sub
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "lohme" <lohme@discussions.microsoft.com> wrote in message
>> news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
>> >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
>> >> dguillett1@austin.rr.com
>> >> "lohme" <lohme@discussions.microsoft.com> wrote in message
>> >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
>> >> >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?
>> >>
>> >>
>> >>
>>
>>
>>

[Pete_UK]

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

Sub show_em()
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.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).EntireRow.Hidden = True
> > End Sub
> >
> > --
> > Don Guillett
> > SalesAid Software
> > dguillett1@austin.rr.com
> > "lohme" <lohme@discussions.microsoft.com> wrote in message
> > news:B7BEA303-AE3F-4AAA-B443-1A3DE1BBC8B1@microsoft.com...
> > >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
> > >> dguillett1@austin.rr.com
> > >> "lohme" <lohme@discussions.microsoft.com> wrote in message
> > >> news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> > >> >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?
> > >>
> > >>
> > >>
> >
> >
> >

[Pete_UK]

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
> > dguillett1@austin.rr.com
> > "lohme" <lohme@discussions.microsoft.com> wrote in message
> > news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> > >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?
> >
> >
> >

[lohme]

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
> > > dguillett1@austin.rr.com
> > > "lohme" <lohme@discussions.microsoft.com> wrote in message
> > > news:C0E53461-3BF0-4075-BB07-FABF21A43A7E@microsoft.com...
> > > >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?
> > >
> > >
> > >
>
>