title: Why won't code in the Worksheet_Change() event run?
body: <p>Update: 
  If I defined range as input_range from A2:P29. Then If Enter in row 30, then it works.  However, the Input_range is not automatically extended and I would like to shift the whole row down not only last row in the range. How could I achieve these two things?</p>
  
  <p><a href="https://stackoverflow.com/questions/10593346/how-to-detect-if-the-cell-being-edited-belongs-to-the-last-row-of-a-defined-name">Previous question</a></p>
  
  <p>Starting with the help of Siddharth Rout, I am able to make this work on new Excel file. However, no matter what I tried on this file </p>
  
  <p><a href="https://www.yousendit.com/dl?phi_action=app/orchestrateDownload&amp;rurl=https%253A%252F%252Fwww.yousendit.com%252Ftransfer.php%253Faction%253Dbatch_download%2526send_id%253D1516438217%2526email%253D2abfadb5544bf569a8ad6c428594527b&amp;s=19104&amp;cid=tx-02002207350200000000" rel="nofollow noreferrer">Sample Excel File</a> - it just does not work. I guess there is some kind of structure to prevent from automating adding row. If so, how can I am able to make the code work?</p>