title: A way to verify specific filter contents
body: <p>I have a spreadsheet that uses a filter on a few columns of data. One of these columns has 10 different possible values. I want to verify that there is a specific filter in place--that is, not just that <code>autofiltermode = true</code>--but to actually check what the value of that filter is. Is there a way to do this in vba?</p>
  
  <p>For example, if I might want to make sure that the user is only looking at <code>customers</code>, 1 of the 10 values in my field. So I'm hoping I can say something like <code>if filtervalue = "customers" then</code>. </p>
  
  <p>Additionally, I don't want to verify cell data, I'm asking if there's a way to verify a filter. </p>