The situation: You have a workbook with variuos sheets which have dates as name, formatted in a '20200101' fashion. You need to replace and expand  a certain formula in all these sheets. Luckily, the parameters and the rules of each sheet are the same so you do not need extra error…

Google Sheets Scripts are Js based. This language is fundamentally different from VBA. Let's take a look to some comparisions. Log a message to the designated logger. Scripts: function HelloWorld() { Logger.log('Hello World'); //Javascript what else.. //console.log for…

The private event handlers of the workbooks offer a wide range of possibilities. The situation: You have saved an Excel file in a shared drive so that others can view it as well, but you would really appreciate it if they would not change anything in it. Of course you could just lock cells for…