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

F5SpecialFormulas. Uncheck all but "Errors" and hit OK.

FormatRowsHide.

Now print the sheet.

When done, unhide the rows.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 13:54:02 -0700, WAVIS
wrote:

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

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
Hide to hide the rows containing those cells. Print the worksheet.

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" wrote:

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

"WAVIS" wrote:

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.