How can I print a worksheet excluding blank rows?

[Don Guillett]

try
columns(1).rows.hidden=false

 

[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

 

[Guest]

Thanks - you and Don were a huge help!

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

 

[Don Guillett]

glad to help