Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells

[Rick Rothstein]

i want to filter out the yes and NO values row in a separate sheet. or delete the rows which have type blank in that sheet.

It sounds to me like your ultimate goal is to reduce the data to only that which does not have a blank type. If your Type column is composed of constant values (that is, there are no formulas in Column BP), then this will delete the rows with blank Types...

Sub DeleteRowsWithBlankTypes()
  On Error Resume Next
  Columns("BP").SpecialCells(xlBlanks).EntireRow.Delete
  On Error GoTo 0
End Sub