Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2021, 07:40 PM
SJCrawley SJCrawley is offline Macro for deleting cell contents based on another cells contents Windows 10 Macro for deleting cell contents based on another cells contents Office 2016
Novice
Macro for deleting cell contents based on another cells contents
 
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
  #2  
Old 06-04-2021, 01:05 AM
Purfleet Purfleet is offline Macro for deleting cell contents based on another cells contents Windows 10 Macro for deleting cell contents based on another cells contents Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

can you add an example workbook so we dont have to waste time recrerating the data
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Event macro: insert row with formulae based on current row, clear selected contents emsa Excel Programming 5 04-17-2020 09:03 AM
Macro for deleting cell contents based on another cells contents Copy a cell's contents across many cells cloa513 Word Tables 13 09-19-2016 11:11 PM
Macro for deleting cell contents based on another cells contents Macro to read cell contents and compare data jrfoley3 Excel Programming 7 07-09-2016 12:25 PM
Macro for deleting cell contents based on another cells contents Selection from cell with list contents autopopulates contents of another cell markharper80 Excel 3 02-16-2015 04:18 PM
Can anyone here tweek this macro for renaming Excel files based on a cell's contents? chrisd2000 Excel Programming 6 07-01-2014 01:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft