Thread: How can I print a worksheet excluding blank rows?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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?








Reply With QuoteReply With Quote