Printing a spread sheet and skipping rows.

  • Thread starter Thread starter Guest
  • Start date Start date
F5>Special>Formulas. Uncheck all but "Errors" and hit OK.

Format>Rows>Hide.

Now print the sheet.

When done, unhide the rows.


Gord Dibben MS Excel MVP
 
The easiest way to exclude the rows from printing is to hide them. With the
desired sheet active, select Edit >> Go To >> Special. Select Formulas,
uncheck everything except Errors, and click OK. All the cells with formulas
returning #N/A (or any other error) should be selected. Select Format >> Rows
Here is the same procedure in a macro.

Sub HideErrorRows()
'Selects all cells with formulas reutrning an error
'on the active worksheet, then hides the rows containing
'those cells.
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.EntireRow.Hidden = True
End Sub

Hope this helps,

Hutch
 
WAVIS said:
I want to print a spread sheet but skip all rows that have #n/a in any cell
in that row.
Click to expand...

Thanks to all. Followed instructions and it works great.
 
Back
Top