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