VBA Newbie Question

[weefatbob]

Apologies if this has been asked before, I am new to VBA and have built a filter for my data....
Sub Filterindata()
Range("A1"). Autofilter Field:1,Criteria1:=Array("X*")
End Sub

From this filtered data, I want to delete rows where column H, which is headed line Manager Y/N, where the value is equal to N. I only want I to work on the filtered rows.

Is this possible?

TIA

 

[Fluff]

How about

Sub Filterindata()
Range("A1:H1").autofilter 1, "=X*"
Range("A1:H1").autofilter 8, "=N"
ActiveSheet.autofilter.Range.Offset(1).EntireRow.Delete
End Sub

 

[weefatbob]

You Sir are genius....Thank you very much

How about

Sub Filterindata()
Range("A1:H1").autofilter 1, "=X*"
Range("A1:H1").autofilter 8, "=N"
ActiveSheet.autofilter.Range.Offset(1).EntireRow.Delete
End Sub

 

[Fluff]

Glad to help & thanks for the feedback