help to maintain Range used

[sebastianaditya]

hi master.
i need your help for macro code this ilustration

I use Range A1:A50.
When Range A40:A50 deleted i want insert new row Maximum A50 and if another Cell A delete it will back to previous Range used. Could you give me clue for this Case??

Thank you