Hi Try
Sub Test() Last = Cells(Rows.Count, "A").End(xlUp).Row For i = Last To 1 Step -1 If IsError(Cells(i, "A")) Then Cells(i, "A").EntireRow.Delete End If Next i End Sub On Fri, Apr 15, 2011 at 3:24 PM, Prabhu <prabhugate...@gmail.com> wrote: > Hi, > > I want to delete particular rows only in my work sheet which contains #N/A > in a particular column? > > Assuming the column containing the #N/A errors is column A, and i need to > delete the entire row where '#N/A' if found in column A. > > Plz help with macro code *which should delete enter #N/A at one time not > line by line*. > > Regards, > Prabhu > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel