I am trying to create a macro that would clear the contents of Columns A,D,and F when column W is equal to zero. The data is on the same row, and I only need it to apply to a select number of rows (11-45) because of summary data in other rows. How would I achieve this?