I am trying to delete information in a table once it has been filtered.
All the information that appears in the table after it was filtered has to be deleted.
I have the following attempt to write the macro:
With Sheets("Initiative Summary").ListObjects("InitiativeTbl")
.Range("Functional Area").EntireColumn.Select
Selection.EntireRow.Delete
End With
"Functional Area" is the name of the column in the InitiativeTbl table. I prefer to use the name of the column and not a cell number in case there are some changes or additions made to the table.
Could you please help me figure out what's the best way to write this macro?