title: Copy-paste doesn't trigger worksheet_change
body: <p>Here is what I need to do: When I have written something into a cell in the sheet, my <code>Worksheet_Change</code> code should check if the cell contains certain characters and then replace those characters. That part of the code is working fine. </p>
  
  <p>However there is a slightly odd behavior. Here's the code so far: </p>
  
  <pre><code>    Private Sub Worksheet_Change(ByVal Target As Range)
          Target.Value = Replace(Target.Value, "ÃŸ", "ß")
  
          MsgBox "This is the value: " &amp; Target.Value
      End Sub
  </code></pre>
  
  <p>What's happening is that when I have the characters that need to be changed in my clipboard (using <kbd>Ctrl</kbd>+<kbd>C</kbd>). When I double-click onto the cell, paste the characters into the cell using <kbd>Ctrl</kbd>+<kbd>V</kbd>, and then press Enter, the code works just fine, the characters are changed. (Note: Without the double-click, you can't see the cursor.)</p>
  
  <p>However, if I just go to the cell with my arrow keys and paste over whatever else is in the cell, nothing happens.  I suspect the <code>Worksheet_Change</code> isn't even triggered, or else it would at least display my <code>MsgBox</code>.</p>
  
  <p>(I don't know if it's relevant to this, but i am using Excel 2010 in a Mac)</p>