suggestion,


Keep track of the current activecell of selection value maybe?

using the worksheetchangeselection event

--
When you lose your mind, you free your life.


"blatham" wrote:


What is the best way of identifying if the worksheet change event was
triggered by anything other than a change in the contents of a cell?

I want to be able to handle cell changes but am not interested in other
events such as inserting/deleting rows etc and want to exit the sub in
these situations.

The solution presumably involves some sort of test on the 'target'
range. Any ideas?


--
blatham
------------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...o&userid=19441
View this thread: http://www.excelforum.com/showthread...hreadid=483668