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?
> >>
> >>
> >>
>
>
>