title: Set Excel Autofilter Values with VBA
body: <p>My spreadsheet has an autofilter set to cell A8 that has the options L, B, U and (Blanks) and range A9:A532.</p>
  
  <p>I would like a macro that when it has been run, its selects the B, U and (Blanks) options (or conversely deselects the L option) and therefore the relevant rows are filtered. I've had a look around what everything I have found so far hasn't worked.</p>
  
  <p>Thanks in advance</p>