VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

I am absolutely new to excel VBA.

I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references.

What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns.

Following are the issues that I want help with:

When inserting / deleting row / rows, get error "Type Mismatch error 13"
The same error appears while certain columns are extended down to the cells.
Same error while cut copy pasting a row
Although the run time error occurs, the action is partially completed

Earliest response would be much appreciated.

My sample excel is attached

This has been resolved now. Thanks

Yes, it was...

http://www.ozgrid.com/forum/showthread.php?t=203108

Please read the forum rules, both here and on OzGrid.

I hv posted this on multiple sites, and was informed that cross posting is to be avoided.
Like many novices, I wasn't aware of this as this is my second post.

I would like to rectify that situation. My original post can be found in the below link. Please reply to the same there.

http://chandoo.org/forum/threads/vba...3/#post-199415

Thanks