title: Excel: Previous Values from Ranges
body: <p>I would like to get previous cells values when I copy single cell and paste it to multiple cells. The <a href="https://stackoverflow.com/questions/295165/how-can-i-determine-new-previous-cell-value-on-sheetchange-event-in-excel">How can I determine new &amp; previous cell value on SheetChange event in Excel?</a> is good enough for detecting single cell previous value. However when I am trying to copy one cell (ctrl+v, dragging etc) and apply it to multiple cells, none of the previous values are detected. Instead, the array of values are equal to the first cell, which leads me to the conclusion that cells are changed before SheetSelectionChange event occures. Any idea how to handle this?</p>
  
  <pre><code>private void Application_SheetSelectionChange(object Sh, Excel.Range Target)
      {
          try
          {
              if (Target.Value2 != null)
              {
                  foreach (Excel.Range range in Target)
                  {
                     // Each range in Target has same value as first value instead of previous value
                  }
              }
          }
          catch (Exception ex)
          {
             // Log stuff
          }
      }
  </code></pre>