Delete Row After Autofilter. Right click on any of the selected cells and click on delete row in the dialog box that opens click on ok. Select the entire working area of your dataset.
Dim lnglastrow as long. 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. Click the data tab and click on the filter icon.
Dim lnglastrow as long.
This allows you to delete rows based on values in multiple columns. You can click on any. Right click on any of the selected cells and click on delete row in the dialog box that opens click on ok. Click the data tab and click on the filter icon.
