View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default 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