thanks p45cal
is there anyway code only change to"pp" sheet ? aslo one more change to remove the msg box and do change the value
since there will b lot's of "w" to b changed