Delete Row After Autofilter. The closest post to do what i am looking for is. Public sub deleterowswithautofilter dim wksdata as worksheet.
Dim lnglastrow as long. You need to use offset to move the relevant range down one row to avoid including the headers and then use resize to resize the range to number of rows 1. Sure it s possible to do this quite easily using excel s built in menus select data set auto filter apply filter criteria select rows to delete go to special visible cells only delete reset the filter to show remaining records.
At this point you will see no records in the dataset.
This is how you will use range autofilter. From the data tab select the filter button under the sort and filter group. You need to use offset to move the relevant range down one row to avoid including the headers and then use resize to resize the range to number of rows 1. Delete rows application displayalerts false lo databodyrange specialcells xlcelltypevisible delete application displayalerts true 3.
