title: vba deleting rows that do not contain set values defined in range
body: <p>I have a sheet of data with 25k lines. I need to search the entire sheet for certain words that I've defined in a named range on tab 2, called "KeywordSearh". The range contains a list of words I need to look up in the main data. I want to delete all rows that DO NOT contain these key words (and move all retaining rows up) and retain only the rows with reference to the keywords (including the titles row). Keywords could be written as text inside any cell which will also contain other text, so the search function needs to look within each string and not be case specific. </p>
  
  <p>I think the code on link below is close, but this is does not refer to a range. Also, I only need to search one worksheet called "FAIR".
  <a href="https://stackoverflow.com/questions/17997711/vba-looping-over-sheets-delete-rows-if-cell-doesnt-contain">VBA Looping Over Sheets: Delete rows if cell doesn&#39;t contain</a></p>
  
  <p>I'm a complete novice to VBA so any assistance is extremely appreciated.</p>