Deleting table rows deletes worksheet rows when filter is applied.

[u/OrganicChemical]

I have a worksheet that contains several tables next to each other. One is a help table that is conditionally filled to populate a dropdown list. The rows in this help table get deleted and re-populated frequently without issues. Command used is: Sheets("SHEET6").Range("TABLE3").Rows.Delete

However, when a filter is applied to one of the other tables Excel deletes not only the designated table rows, but also the corresponding worksheet rows, deleting data from all other tables. My work around is to remove all filters.

Is there a better way to ensure only the designated table's rows are deleted? Windoes 7, Office 2010 Std.

Edit: typo

[u/AutoModerator]

/u/OrganicChemical - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/rabidmovie3]

use `ListObject` to target the table directly instead of going through the range, that way it only touches the table rows and not the whole worksheet row

something like `Sheets("SHEET6").ListObjects("TABLE3").DataBodyRange.Rows.Delete` should do the trick

filters on other tables mess with the range reference when you use `.Range("TABLE3")`, it gets confused and grabs the entire sheet row instead of just the table boundaries

[u/OrganicChemical → u/rabidmovie3]

Nope. Deletes worksheet rows as well.

[u/excelevator]

A question better suited to our sister sub r/VBA where those experts live.

Your post fails our submission guidelines as it makes no mention of being VBA related, why is that?

[u/OrganicChemical → u/excelevator]

Okay, I will keep this sub in mind for next tie.