Private sub to make one cell blank when the other cell has value

[tantcu]

hello,

Can anyone help me with a macro code to set cell A1 and A2 depending on one another. For example, if cell A1 has value, then cell A2 has to be blank and the other way around? If both cell blank then nothing happens.

Thanks,

[walruseggman]

Please Login or Register  to view this content.

[tantcu]

Thank you for the code. however both cells are able to have value at the same time.

[YasserKhalil]

May be

Please Login or Register  to view this content.

[tantcu]

I still have the same problem.

[kalak]

Can anyone help me with a macro code to set cell A1 and A2 depending on one another. For example, if cell A1 has value, then cell A2 has to be blank and the other way around? If both cell blank then nothing happens.

try

Please Login or Register  to view this content.