Printing a spread sheet and skipping rows.

[Guest]

I want to print a spread sheet but skip all rows that have #n/a in any cell
in that row.

 

[Gord Dibben]

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

 

[Guest]

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

 

[Guest]

I want to print a spread sheet but skip all rows that have #n/a in any cell
in that row.

Thanks to all. Followed instructions and it works great.