asked on
Hello Experts!
I have a spreadsheet, that calculates figures for me on a daily basis. Each day, I end up clearing out specific cells and/or ranges to bring the spreadsheet back to Day 1.
What would be the macro/code I could copy and paste into my spreadsheet (Yes, I know where to paste a macro, I just don't have a clue how to write it) to clear specific cells & ranges.
IE - I am going to add a button to my spreadsheet, that when pressed does the following...
1.) "Clear Contents" of range E:I
2.) "Clear Contents" of range C7:C8
3.) "Clear Contents" of cell C10
Is this possible?
Thank you in advance for your help!
~ Geekamo
I have a spreadsheet, that calculates figures for me on a daily basis. Each day, I end up clearing out specific cells and/or ranges to bring the spreadsheet back to Day 1.
What would be the macro/code I could copy and paste into my spreadsheet (Yes, I know where to paste a macro, I just don't have a clue how to write it) to clear specific cells & ranges.
IE - I am going to add a button to my spreadsheet, that when pressed does the following...
1.) "Clear Contents" of range E:I
2.) "Clear Contents" of range C7:C8
3.) "Clear Contents" of cell C10
Is this possible?
Thank you in advance for your help!
~ Geekamo
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.