You don't need VBA.

If you unprotect the worksheet, you can click on the Review Tab and, on there, at the right hand side, click on Allow Users to Edit Ranges.

That will display a dialogue box identifying the ranges and permissions. In this case, Mileage Table 2 refers to =$L$2:$L$32,$C$2:$H$32. In that dialogue box, you have the options to modify or delete the range.


Regards, TMS