title: Determine whether user is adding or deleting rows
body: <p>I have a VBA macro that validates user entered data (I didn't use data validation/conditional formatting on purpose).</p>
  
  <p>I am using <code>Worksheet_Change</code> event to trigger the code, the problem I am facing now is, when there are row changes. I don't know whether it is a deleting / inserting rows.</p>
  
  <p>Is there anyway to distinguish between those two?</p>