Runtime Error 13 - Type Mismatch

Hi,

I am new to VBA and have been mashing together lines of code from different sites to get the result I need. It is rough.

I think I have got it all working so far except for when I try and delete multiple items from one column (which are dropdown selections). The problem occurs only in this column and nowhere else. Everything is locked down so users can't see or adjust anything outside of what I have left open.

Code is pasted below. Any help for this would be great!

When I try delete 2 or more selections in one go from column AE the runtime error 13 appears. The thing this piece of code is achieving is a time stamp for when the status of work changes.

Please Login or Register  to view this content.

Try putting this on top of code.

Please Login or Register  to view this content.

Instead of .Value, try .Text.

If the cell that's just been changed has an error like #N/A you will get that error.

In future, please use code tags around your code. I have done it for you on this occasion.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.