thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
Hi Guys,
Is there a way to delete all the rows int he selected autofilter in the below code. At the moment it only looks as rows 2:29.
Thanks
Is there a way to delete all the rows int he selected autofilter in the below code. At the moment it only looks as rows 2:29.
Thanks
Code:
Sub Macro1()
ActiveSheet.ListObjects("Brecon_Mail_Merge").Range.AutoFilter Field:=12, _
Criteria1:="Non Ford"
Rows("2:29").Select
Selection.Delete Shift:=xlUp
Range("Brecon_Mail_Merge[[#Headers],[Column1]]").Select
Selection.AutoFilter
Selection.AutoFilter
End Sub