View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default Printing in Excel2000?

You added a bunch of manual page breaks. Then you hid lots of rows, but the
page breaks still cause blank sheets of paper to come out of the printer?
(Discounting headers/footers.)

If that's what you mean, then how about just copying the visible rows to a new
worksheet and print from there.

Select your range
edit|goto|special|visible cells only
edit|copy
edit|paste in that new worksheet.

You'll have to reapply the pagebreaks you want.

....
Or you could copy the worksheet
edit|move or copy sheet
then remove all the hidden rows on that sheet.
then print
and delete that helper sheet.

You could even use a macro:

Option Explicit
Sub testme()
Dim curWks As Worksheet
Dim tempWks As Worksheet
Dim iRow As Long
Dim LastRow As Long

Set curWks = Worksheets("sheet1")
curWks.Copy 'to a new workbook
Set tempWks = ActiveSheet

With tempWks
LastRow = .Cells.SpecialCells(xlCellTypeLastCell).Row
For iRow = LastRow To 1 Step -1
If .Rows(iRow).Hidden = True Then
.Rows(iRow).Delete
End If
Next iRow

.PrintOut preview:=True

.Parent.Close savechanges:=False
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

PaulM wrote:

Is it possible to suppress printing of hidden pages (rows) in Excel2000?


--

Dave Peterson