VBA Runtime Error - '424' Object Required

Hi all,

I have a code running on my accounting spreadsheet that is supposed to move an invoice from one worksheet to another when its status is changed from a dropdown. for example - Invoices come in and are input onto this spreadsheet and once paid, i want them to move accross to a worksheet called 'Approved' and then if disputed move to a different worksheet.

The code i have in place is as follows.

Please Login or Register  to view this content.

Everytime i try and change the status of an invoice, i get a runtime error 424. However it does still run the macro ie the invoice moves accross anyway!

Any help/advice would be appreciated.

Thanks