title: EXCEL 2010 Run-time error '50290' Method "_Evaluate' of object'_Worksheet' failed
body: <p>Then i double click on cell with data validation and then try to select from dropdown I get error Runtime error Run-time error '50290'. Method "_Evaluate' of object'_Worksheet' failed</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  Select Case Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
      Case Is &lt; 5
          LastRow = 5: CountRow = 0: R = 1
      Case Is &gt; 5
          LastRow = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row: CountRow = LastRow - 4: R = 0
      Case 5
          LastRow = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row: CountRow = LastRow - 4: R = 1
  End Select
  End Sub
  </code></pre>
  
  <p>on </p>
  
  <pre><code>Select Case Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
  case 1
        msgbox "hello"
  end select
  </code></pre>
  
  <p>Runtime error Run-time error '50290'. Application-defined or object-defined error.</p>
  
  <p>on</p>
  
  <pre><code>Select Case Cells.Find(What:="*", After:=Range("A1"), SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
  </code></pre>
  
  <p>Why this happens?</p>