Tony,

This is definitely putting me on the right track, although there's still
some way to go.

Thanks a lot for your help

Pete



"tony h" wrote:


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