Your code worked anything enter in cell D2 it clears the data in cell C2
But I requested that it works only for two Words i.e. "Best" & "Worst".
One more thing these two words can be enter within this range D2 to D1000
then it clears data where ever the above mention words enter within the specified range.
There is no merging cells
I have tried in many ways
the table consist of A to F Columns
it contains data in all column
I have remove data one by one by one from A, B, E, & F columns then copy code to Sheet and apply but still shows an error.