Deleting a row within a named worksheet if cell = No

I am trying to delete a row within a named worksheet if the value in column W = No.

I have looked at various examples on this forum but cant adapt to make it work. Would any of the members have some code that would help.

Thanks

Thanks Alphafrog for the response

I've changed my plan to filter if the cell in column W =" " and column v = "Yes"

The code I've used is below. Can you shed any light as to why if fails on line 3

Application.ScreenUpdating = False
With Sheets("Sheet1").UsedRange
.AutoFilter Field:=23, Criterial:=" "
.AutoFilter Field:=22, Criterial:="Yes"
.Offset(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
.Parent.AutoFilterMode = False
End With
Application.ScreenUpdating = True

Thanks for any help you can give.

Thanks again for your help.

I'm trying to base the delete row on multiple criteria but it will not delete any rows. The code is below. Any chance you could point me in the right direction. I'm guessing it doesn't like the multiple filter on column 22.

Application.ScreenUpdating = False
With Sheets("Prior Absence").UsedRange
.AutoFilter Field:=23, Criteria1:="="
.AutoFilter Field:=22, Criteria1:="Yes"
.AutoFilter Field:=22, Criteria1:="NOA Started"
.Offset(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
.Parent.AutoFilterMode = False
End With
Application.ScreenUpdating = True

Thanks again

Thanks again Alphafrog.