Clear contents of Same Range in Multiple worksheets in Excel Online

Hi Experts,

Can you help me with a script that would clear the data (not the formatting) from cells in a Range (ex: D14:AH30) on all worksheets in the workbook except for one worksheet named (Options or could be anything)?


Thank you in advance for your help.

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...orksheets.html

I have moved the original thread to the Office 365 section and amended the title, which is what I told you to do. I did not tell you to open a new thread.