Warn if Cell/Column/Row Contains a Range Name
in [Programming]
|
Prev: Need to find a value in a range and take action if its there
Next: command for save and close my page
From: Paige on 18 Jul 2008 16:22 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?
From: Wigi on 19 Jul 2008 12:53 This is very hard to do. To begin with, you can't catch the fact that a row or column is deleted. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Paige" wrote: > 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?
From: Paige on 21 Jul 2008 10:53
Thanks! "Wigi" wrote: > This is very hard to do. To begin with, you can't catch the fact that a row > or column is deleted. > > > -- > Wigi > http://www.wimgielis.be = Excel/VBA, soccer and music > > > "Paige" wrote: > > > 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? |