VBA to delete rows

I am trying to write a macro that deletes rows based on certain criteria. I have rows with the word "Summary:" in it that I want to keep (no problem). My issue is that i then have rows that all begin with "Application:". What comes after that is different (i.e. Application: Start, Application: End). I need help creating this wildcard search as I have tried with no succes. This is what I have so far:

Please Login or Register  to view this content.

Hello mannm4,

You can use the Like operator to perform partial matches on strings.

Please Login or Register  to view this content.

Returns True if the start of the string matches, otherwise False.

Hi,

Wherever possible you should try and avoid looping through cells, particularly with large ranges since there is a time overhead each time the VBE jumps back to the Excel Application (and vice versa) to perform a task, as it does each tine it deletes a row. It's always much better to use standard excel functionality and use that.

So in this case make the first part of the macro a task to create an Excel function that identifies which rows should be deleted and copy that down a helper column adjacent to your data. For instance

Please Login or Register  to view this content.

Now filter your range using this helper column and select on "Delete", then finally delete all the filtered rows. You can use VBA code like:

Please Login or Register  to view this content.

HTH