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 .....
![Capture.JPG Capture.JPG](https://www.mrexcel.com/board/data/attachments/113/113327-cce87f76e3d54135d8d4bd868d2f639f.jpg?hash=zOh_duPVQT)
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 .....
![Capture.JPG Capture.JPG](https://www.mrexcel.com/board/data/attachments/113/113327-cce87f76e3d54135d8d4bd868d2f639f.jpg?hash=zOh_duPVQT)
I upload an image to better understand my thoughts.
Thanks in advance