|First, a posting tip: |
Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum so that it is easier for us to read. Please keep the pre tags in mind the next time you post VBA code. Thanks!
Second, it appears that you amended the code in such a manner that it no longer works.
You have 3 If instructions but only 2 End If's. That won't work.
Third, you say that you want to amend the code to "move a row to another sheet" when Moved is selected, but you don't say what sheet you want to move the row to. If it's being moved to the Closed sheet, then all you need to do is change one line:
If Target = "Closed" Or Target = "Moved" Then
If you want it moved to a different sheet, then there are numerous ways to accomplish that, depending on where you want it moved to. Please clarify that requirement and we'll take it from there.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.