Posted on 2012-12-29
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!