title: Worksheet Change event not working after pasting values
body: <p>I have a code in <code>Worksheet_Change</code></p>
  
  <p>If a column 9 is updated then the column 8 will be automatically populated by multiplying with col 9 and col 11.</p>
  
  <p>But when the user pastes the values in the column, the change event does not work correctly. Only the first cell in the Col 8 gets updated. </p>
  
  <p>How can I overcome from this?</p>