Macro to delete cell content based on cell value

Each cell in Column CB is either blank or contains "X." If a cell in Column CB contains an "X", I want the macro to clear the data in Columns CC:CJ.

For example...

if CB10 = X, clear contents of CB10 through CJ10.
Then move to CB11. If CD 11 = X, clear contents of CB11 through CJ11.

Is this possible?

Thanks,
Steve

If CD 11 = X
meant If CB 11 = X

Assuming your data in sheet1

Please Login or Register  to view this content.