View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Posse John Posse John is offline
external usenet poster
 
Posts: 9
Default 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.