Hello All, I would like to know if there is a way to delete specific cells based on another cells value on close/save of wookbook.

For instance, if cell G2 = 1, I would like to delete B2:F2
If cell G15 = 1, I would liek to delete B15:F15
and so on down to row 2,500.

Column G will always be the deciding value cell, and cells B-F will be the ones delected if G is equal to 1.

Thanks in advance