the .target will not refer to anything when the row, cell or column has
been deleted. This is your indication that the structure has changed.

to test for this you can use
if .target is nothing then
'row/col deleted
else
'do your stuff
end if


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=501980