ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Checking if the TARGET has been deleted (https://www.excelbanter.com/excel-programming/352035-checking-if-target-has-been-deleted.html)

Peter Rooney

Checking if the TARGET has been deleted
 
Good morning, all! :-)

I remember reading somewhere where you could check to see if the TARGET
range in a change macro has been deleted, but I can't remember where it was.

I use an intersect to check if the change is being made in a particular
range, but if I select a cell in that range and delete the row or column, I
get an error.
Can anyone point me in the right direction, please?

As always, thanks in advance

Pete




All times are GMT +1. The time now is 12:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com