Hi Everyone,
I would appreciate assistance with the following problem if possible.
I require a Macro that will clear the contents of cells in row BD8:BI8 when the corresponding cell AT8 is either blank or zero (0). As soon as cell AT8 contains a value greater than zero (0) then any contents in cell range BD8:BI8 must remain undeleted.
I require the same functionality to apply to all subsequent rows up to BD40:BI40 when the corresponding cell AT40 is subject to the conditions outlined above.
Is there a solution?
Thanks Very Much. SC
I would appreciate assistance with the following problem if possible.
I require a Macro that will clear the contents of cells in row BD8:BI8 when the corresponding cell AT8 is either blank or zero (0). As soon as cell AT8 contains a value greater than zero (0) then any contents in cell range BD8:BI8 must remain undeleted.
I require the same functionality to apply to all subsequent rows up to BD40:BI40 when the corresponding cell AT40 is subject to the conditions outlined above.
Is there a solution?
Thanks Very Much. SC