I've been using the formula below to clear a specific range depending on the criteria in another cell.
The problem I'm having is I want to extend the entire formula for if range B2:B19 is changed, clear the correlating row's range based on the case criteria, without creating an independent statement for each row. I'm a bit of a notice and think there may be a simple solution to this.
Please Login or Register to view this content.
Last edited by Oxygen Potassium; 08-21-2017 at 09:10 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I apologize for the etiquette. Thank you for pointing this out.
How does this work for you ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you bakerman2. I like that method but just found another using a variable instead of target.offset. This seems to solve my problem.
Please Login or Register to view this content.
Why would you wanna loop 17 cells every time you only change 1 ?????
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks