LinkBack URL
About LinkBacks
Hi guys
I have a drop down list in cell C199, and cells dependent on this. How can I clear cells C200 to cell C210 if a new selection is made from the drop down list mentioned in C199?
Many thanks in advance
Dean
Hi guys
I have a drop down list in cell C199, and cells dependent on this. How can I clear cells C200 to cell C210 if a new selection is made from the drop down list mentioned in C199?
Many thanks in advance
Dean
When you say clear do you really mean delete anything in C200:C210?
If so just use a sheet change event that recognises when C199 is changed and use VBA to Clear C200:C210
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Another possibility, depending on if you have a formula in C200:C210, you be to include in that formula an option to show "blank" if a blank is selected from the DD?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks