I have a worksheet change event I need to modify. The event modifies the value of a cell if the adjacent cell meets a criteria. I want the event to fire if I paste data into the target range and to fire for every cell. Specifically, my macro says if the value of any cell in column BB, is zero, then the value of the cells 2,4, and 6 columns to the right should also be zero. If the zero is deleted, the other cells should revert to blank. If someone pastes a column of zeros into the range, at present the macro only changes the cells to the right of the very top of the paste range. I would like the macro to work for every cell in the range; so a column of zeros pasted creates columns of zeros to the right.

Here's my code:

Please Login or Register  to view this content.