Filter-delete #N/A in one column, ONLY IF all other columns blank?

[Gingertrees]

I have a spreadsheet where a "comment" section tends to have 100s of rows of trailing "#N/A"s. My initial thought was simply to filter on the comment column and delete those rows. But sometimes there is an #N/A in a row that has other useful info. To better explain:[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Field2[/TD]
[TD]Field3[/TD]
[TD]Comment[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]cat[/TD]
[TD]123[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]dog[/TD]
[TD]3333[/TD]
[TD]Fido[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
Since other columns in row 2 have info, I do not want to delete row 2 despite the error in the comment section. The last two rows, however, are useless and could be deleted.

Here is my code to delete #N/A in field 4 (comment). How do I change this to filter out ones where the other columns are NOT blank?

    FullrangeII.AutoFilter field:=4, Criteria1:="#N/A", Operator:=xlAnd
    '//////Field 4=comments. Tweak as necessary.
    
    ActiveSheet.Range("A3:EE" & LastRow).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    ActiveSheet.ShowAllData

 

[vds1]

Hello

You may loop through all the columns and filter by blank. After which delete the visible cells.

Dim i As Integer
'// Loop through each column and filter by blank (Column A to C)
For i = 1 To 3
    FullrangeII.AutoFilter field:=i, Criteria1:="", Operator:=xlAnd
Next i
'// Filter Comment Column for #N/A (Column D)
    FullrangeII.AutoFilter field:=4, Criteria1:="#N/A", Operator:=xlAnd
'// Delete Visible cells after filter
    Range("A3:EE" & lastrow).SpecialCells(xlCellTypeVisible).EntireRow.Delete
'//Remove filter
    ActiveSheet.AutoFilterMode = False

 

[Gingertrees]

Great! That was just what I needed. Thank you a lot