help to maintain Range used

sebastianaditya

New Member
Joined
Sep 17, 2014
Messages
1
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:)
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,108,499
Messages
5,523,286
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top