title: Perform a find on hidden cells
body: <p>I have a computed range of values in a hidden column which I use for a dropdown box. To figure out which value the user has selected, I try to run a Find on that range, but for some reason Excel won't return the cell corresponding with their selection so long as the column is hidden.</p>
  
  <p>How can I get Find working on cells in the hidden range. Remember - I'm searching cell calculated values, not formulas.</p>
  
  <p>The following does not work:</p>
  
  <p><code>Set inserted = Range("RDS_Event_IDs").Find(Range("SelectedEvent"), , xlValues, xlWhole)</code></p>
  
  <p>so long as cells in <code>Range("RDS_Event_IDs")</code> is hidden.</p>
  
  <p>Because the solution has to work in general situations, where some or all of the the range being searched might be hidden, and the entire sheet might be searched, it isn't feasible to programmatically un-hide all affected rows and columns and then re-hide the ones that were previously hidden.</p>