View Single Post
 
Old 06-03-2021, 07:40 PM
SJCrawley SJCrawley is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2021
Posts: 1
SJCrawley is on a distinguished road
Default Macro for deleting cell contents based on another cells contents

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
Reply With Quote