I have been using data Validation to alert users when data
is input incorrectly. However, rows need to be inserted
into the middle of the spread sheet and formulas pasted in
those rows. So my warnings are getting knocked off.

Can I do the same with a macro? Running for the whole
column and all the time?

If data entered in Column H: A message box saying "Must
Use Valid Date"

If Cell is used in D2 and not its precedent cell in C2 A
message Box saying "Must Enter Depreciation Period"


Thanks, Todd