Change Event code
This seems easy, but select case and if statements have not worked for me.
Range of cells THESE = D48, I48, N48
Range of cells THOSE = D49, I49, N49
If any cell in THESE change then clear all THOSE.
If any cell in THOSE change then clear all THESE.
Howard
|