Cells in Column M have a data validation drop-down list. If the user selects 'Closed', I want this code to run:
This code works fine run on its own. But as soon as I run it from the change event (code below) it falls over.Please Login or Register to view this content.
I get a Type Mismatch on If Target.Value = "Closed" Then. Can someone explain why this is happening?Please Login or Register to view this content.
-Militia
Bookmarks