problem in running worksheet_change code

The code runs wrongfully i want that if in the target column any cell having text "rejected" than auto insert row below that with formula wherever formula is there.

Please rectify the code and send me as soon as possible..

Please Login or Register  to view this content.

hello patel45
yah my code does not search "rejected" i know that but i want that if in target.column 20(i.e column T) if "rejected" will be entered then a row below that should be inserted below that....

so please rectify the same as mentioned above...
Thanks Patel in Advance

see in column T there is dropdown for "accepted and rejected" . i want that if anyone select from dropdown "rejected" then an automatic row should be inserted below that with same formula..in my sheet i have written vba for auto row insert but i want that if in column T "rejected" is selected from dropdown the auto row insert code should run else it should not run...

hello patel please help me out of this its very necessary

thank u very much patel45
it works