Requesting help with the VBA to delete the filtered rows from an Excel Table. I do not want to delete the entire row but only the row in the table. I understand the code below will delete the hidden table rows but it also deletes the entire row which I want to avoid. Only the table row should be deleted.
For Each rw In [Tbl_Mstr].Rows
If rw.Rows.Hidden Then
Sample file with a filtered table is attached. The Table name is "Tbl_Mstr".
Thank You - Jerry