delete row with #N/A

  • Thread starter Thread starter bijan
  • Start date Start date
B

bijan

Hi All,
How can I delete entire row that contain error #N/A in a certain cell?
any help would be appreciate
Bijan
 
Hi,

Suppose the NA's are in column A, Select all the data in column A and press
F5, click Special, select Formula (if the cells with the NA's are formulas,
otherwise constants). Click OK. Press Ctrl+- (control and minus) choose
Entire Row and click OK.

If there is only one cell with NA, just select the row and press Ctrl+-.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Dim rng As Range

On Error Resume Next
Set rng = Columns("G").SpecialCells(xlCellTypeFormulas, 16)
On Error GoTo 0
If Not rng Is Nothing Then

rng.Delete
End If
 
Back
Top