Ahh ok maby i dint understand what you where doing.

Though with the worksheet change event the TARGET is the range value
that is going to be changed, And to the best of my knoledge this cannon
be changed.

Maby you would be better off decribing why you think you need to do
this. and from there there may be a solution.,

cheers/.


--
D_Rennie
------------------------------------------------------------------------
D_Rennie's Profile: 1412
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=172761

Microsoft Office Help