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:

ID	Field2	Field3	Comment
1	cat	123	#N/A
2	dog	3333	Fido
			#N/A
			#N/A

<tbody>
</tbody>

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