change event delayed fire for data validation list

I want to run multiple change events in one worksheet; the change to run is range dependent. I have the following code, which sort of works. I don't get any errors and the changes I want eventually happen, but only after I click back and forth between cells. The codes work beautifully separately, but not so well in the combined change event.

I have multiple columns. Every other column has a drop down list with 2 options, "Data" and "No Data". If the value in column C is "no data", then the adjacent cell in columns D, F, H should equal ".N". If the value of any cell in column E is "No Data", then the value of F should be ".N', likewise for column G triggers H. There will be more change events, all in the same worksheet, with similar logic.

Thoughts?

Please Login or Register  to view this content.