•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Row deletion macro comman
Our take
Are you frustrated with legacy spreadsheet macros that only delete rows with exact text matches? You're not alone. Many users seek a more flexible solution that can remove entire rows based on partial matches, such as identifying rows containing "Dup_" rather than requiring an exact match. In this guide, we'll explore a macro command that can be adjusted to meet this need, empowering you to efficiently clean your data and streamline your workflow. Read on to discover how to enhance your macro for optimal performance.
Hi guys.
I manage to copy a macro command that deletes the entire row if a cell contains a text. However what we need is if the cell itself hasa specific text
Example
Dup_this
I need to delete rows that has the value "Dup_" but using the command I found only works if the cell is the exact match
[link] [comments]
Read on the original site
Open the publisher's page for the full experience