Deleting Rows that Match/Contain Search Criteria
I import data for an external source into Excel. I sort and format the data
programatically.
This data contains some information that I need to delete. Searching that
range by using the following:
Columns("A:A").Find(What:="74RM",... ).Activate
How do I delete the entire row when the search criteria is found? I'm also
having difficulty understanding how to trap the error that occurs when the
search critieria is not found.
|