I want to only delete rows that are visible in an Excel Data Table. Here is the code that I tried:
it keeps giving me an error. Please helpwsWorking.ListObjects(1).Range.AutoFilter Field:=lngColumn, Criteria1:=aKeep, _ Operator:=xlFilterValues Selection.ListObject(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete