I was hoping someone here could possibly tell me how I could add a clear button to my spreadsheet. I only want to clear specific cells. Let's just assume A1, C1, and E3 for now.
I was hoping someone here could possibly tell me how I could add a clear button to my spreadsheet. I only want to clear specific cells. Let's just assume A1, C1, and E3 for now.
a simple record macro
no doubt theres easier but that should get you on your way![]()
Please Login or Register to view this content.
You can create a named range, and then clear that.
For example, select all the input cells you want to clear (using Ctrl+click to select multiple cells), and then in the Names box (left of the Formula bar), type rgnInput
Then use
![]()
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks