Hello all,
I need to clear a range of cells based on a reference cell.
O5 would be the reference cell. O5 will have a dropdown list ("Clear" & "Select") and when "Clear" is selected, A pop up message: "Are you sure?"
Yes, A5,C5:N5 contents cleared. (B5 is a hidden helper column)
C5,E5,G5,I5,K5,M5= "Spare" (Each cell prints "Spare")
O5 goes back to "Select"
Select C5
End.
I would like the macro to work the same when O9 is the dropdown list ("Clear") and all above applies to row 9.
So, anywhere "Clear" is selected in column O, the same row will show the results of the macro.
Any help is greatly appreciated!
Russ
I need to clear a range of cells based on a reference cell.
O5 would be the reference cell. O5 will have a dropdown list ("Clear" & "Select") and when "Clear" is selected, A pop up message: "Are you sure?"
Yes, A5,C5:N5 contents cleared. (B5 is a hidden helper column)
C5,E5,G5,I5,K5,M5= "Spare" (Each cell prints "Spare")
O5 goes back to "Select"
Select C5
End.
I would like the macro to work the same when O9 is the dropdown list ("Clear") and all above applies to row 9.
So, anywhere "Clear" is selected in column O, the same row will show the results of the macro.
Any help is greatly appreciated!
Russ