Worksheet Change Event Causing Runtime Error 9

Hi All,

I've created a little workbook to keep track of my to-do list (see attached). I have a data validation list in column A, and I use the following code to move lines from one worksheet to another when I change the value in column A:

Please Login or Register  to view this content.

It works when I change the value and then run the macro manually. But when I try to use a worksheet change event to automate the process, I keep getting run-time errors because of the bold line above. I've tried calling the macro from the change event, and I've tried putting the code directly into the change event. Same each time.

Please Login or Register  to view this content.

Any idea how to fix this?

Mumps, that's a really elegant solution!

It works even better than doing it my way. Thanks so much!!!