Hi, Everyone
Hope all are fine.
I am working on a worksheet with some data related to other cells. In this worksheet, if any cell in between W9:W1200 is empty then any data input in the same row of AC and AD will be cleared.
As before, if any cell between X9:X1200 is empty, then any data if input in the same row of AE and AF will be cleared.
Can it done with the VBA? If, please .....

I upload an image to better understand my thoughts.
Thanks in advance
Hope all are fine.
I am working on a worksheet with some data related to other cells. In this worksheet, if any cell in between W9:W1200 is empty then any data input in the same row of AC and AD will be cleared.
As before, if any cell between X9:X1200 is empty, then any data if input in the same row of AE and AF will be cleared.
Can it done with the VBA? If, please .....

I upload an image to better understand my thoughts.
Thanks in advance