http://stackoverflow.com/questions/10220906/how-to-select-clear-table-contents-without-destroying-the-table Version improved for my needs checks if data has not been cleaned already:
With .ListObjects("Table3")
.Range.AutoFilter
If .DataBodyRange.Rows.Count > 1 Then
.DataBodyRange.Offset(1).Resize(.DataBodyRange.Rows.Count - 1, .DataBodyRange.Columns.Count).Rows.Delete
End If
.DataBodyRange.Rows(1).Cells.ClearContents
End With
Brak komentarzy:
Prześlij komentarz