Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to print a spread sheet but skip all rows that have #n/a in any cell
in that row. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Trouble with skipping rows | Excel Worksheet Functions |