title: Search in filtered list
body: <p>I have a simple worksheet A containing a list of strings under the same column. Moreover, from another sheet B I have a macro that searches for the former strings in the list. Everything works fine except for the case when a filter is applied to the list in worksheet A.
  In this case, the search acts like the elements filtered in the list don't exist.</p>
  
  <p>Is there a way to refer to the original list without caring whether the list displayed is filtered or not?</p>
  
  <p>The macro that access the list:</p>
  
  <pre><code>Worksheets("A").Range("A:A").Find(Cells(row, 1).value, LookIn:=xlValues, lookAt:=xlWhole, MatchCase:=True)
  </code></pre>
  
  <p>I gave a look into <a href="https://docs.microsoft.com/en-us/office/vba/api/excel.range.find" rel="nofollow noreferrer">Find</a> but I didn't find useful workarounds.</p>