title: Dynamic selection of visible rows after advanced filtering
body: <p>I have a code that first trough advanced filtering, filters a table. After this i want to select all rows in the table except the headers and delete this. In my table i have 20 columns of data and it some rows have data in the first 10 columns and empty cells between column 11 and 20 so i cant really use selection.end(xldown, xlright).select etc because som rows have empty cells. </p>
  
  <p>I cant get my head around how to fix this selection. DO u pros have any tips for this?</p>
  
  <pre><code>Sub notWanted()
  
  Range("TabellInDataPivot[[#All],[Projekt]]").AdvancedFilter Action:= _
      xlFilterInPlace, CriteriaRange:=Sheets("Groupfiles").Range("C8:E9"),   Unique _
      :=False
  
      lastrow = ThisWorkbook.Worksheets("GruppData").Range("A" &amp; Rows.Count).End(xlUp).Row
       .Range(.Cells(4, 3).Offset(rowoffset:=1), .Cells(lastrow, 20)).SpecialCells(xlCellTypeVisible).Select
  
       Selection.EntireRow.Delete
       ActiveSheet.ShowAllData
  End Sub
  </code></pre>
  
  <p>I get an invalid or unqualifed reference error with the code line .Range**(.Cells**(4, 3) Altough this works fine at earlier filter and delete segments. </p>
  
  <p>Thanks in advance
  /D</p>