khalid79m
09-08-2009, 04:43 AM
Range "Comp1" is column a3 to the lastrow with data.
If Comp1 contains either "No_Error," or ", No_Error" or "N/A," or ", N/A" then clearcontents of that cell.
eg a9 which is within the range Comp1 has the following in it
"C36, No_Error" then this meets the criteria above so a9 should now be blank as the contents would have been cleared.
:dunno
If Comp1 contains either "No_Error," or ", No_Error" or "N/A," or ", N/A" then clearcontents of that cell.
eg a9 which is within the range Comp1 has the following in it
"C36, No_Error" then this meets the criteria above so a9 should now be blank as the contents would have been cleared.
:dunno