Posted: Tue Feb 10, 2009 9:01 am
You can only "replace" from the last column towards the first column with no "error" columns between them. So while...
ColA Error
ColB Error
ColC Replace
ColD Replace
Is legal,
ColA Error
ColB Replace
ColC Error
ColD Replace
Would not be and would generate your error for ColB.
ColA Error
ColB Error
ColC Replace
ColD Replace
Is legal,
ColA Error
ColB Replace
ColC Error
ColD Replace
Would not be and would generate your error for ColB.