Warn if Cell/Column/Row Contains a Range Name

[Paige]

Is there a way to have a msgbox pop up whenever you are trying to delete a
range that contains a range name? If so, can it also provide the affected
cell address(es)? If not, is it possible to even get a warning after the
fact that you just deleted a range name?

 

[Wigi]

This is very hard to do. To begin with, you can't catch the fact that a row
or column is deleted.

 

[Paige]

Thanks!

This is very hard to do. To begin with, you can't catch the fact that a row
or column is deleted.