delete rows from a worksheet

[KCHAWK]

My file includes certain rows where the value in J5:J100 contains #N/A values. These rows are of no use in my analysis and I am trying to create a macro to remove just those rows where the value in col J is#N/A. Could someone give me a hand?

Thanks,

Larry

 

[VoG]

Try

Sub test()
On Error Resume Next
Range("J5:J100").SpecialCells(xlCellTypeFormulas, xlErrors).EntireRow.Delete
End Sub

 

[KCHAWK]

Thank you. Worked PERFECTLY!! Is there somewhere I can see the various choices available for (xlCellTypeFormulas, xlErrors??

 

[VoG]

Yes. In the code window click anywhere in SpecialCells and press F1.

 

[KCHAWK]

Peter: Thank you again.

Larry