1 vote

Move row to very bottom of sheet (Google Sheets Apps Script)

"moveRows/insertRowAfter/deleteRows" Dance My first reaction was that Jacktose was wrong and I wrote this to prove it. But as Jacktose comments - this is merely the "dance". I was ...
  • 4,973
1 vote
Accepted

Possible to make a Google sheet macro available to all sheets I access?

Technically speaking it's not easy to make a macro available to all the spreadsheets. It's possible to create an add-on to make available a Google Apps Script project to all the spreadsheet but at ...
  • 42.6k
1 vote

How to emulate behavior or cmd + down arrow in Google Sheets Macros?

Use getNextDataCell(), like this: const spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getCurrentCell() .getNextDataCell(SpreadsheetApp.Direction.DOWN) .offset(1, 0) .activate(...
  • 8,182
1 vote
Accepted

Solver in Google Sheets Macros

Short answer: No because Google Sheets hasn't a built-in Solver feature and because macros can't be used to automate features added by add-on. As an Excel user that knows about Excel's macros that is ...
  • 42.6k
1 vote

How to enable macros

In Google Sheets macros only works for editors, not for viewers. Regarding saying no to the authorization request, the way to show the authorization again when it was previously denied, is by running ...
  • 42.6k
1 vote

Google sheets macro to run on worksheet change

See Tanaike's gist "Change Tab Detection on Google Spreadsheet using onSelectionChange Event Trigger with Google Apps Script". You may also want to take a look at the jumpToToday_ script ...
  • 8,182
1 vote

How to select and remove drawing object in macro

You want to copy a spreadsheet template by clicking a button, and then delete the button in the newly copied spreadsheet. You are using a macro to copy the spreadsheet. A macro is a Google Apps Script ...
  • 4,973
1 vote
Accepted

How can I make an attendance table that automatically deletes obsolete day and creates a new?

The following is offered on the basis that there are usually many ways to solve a problem. This is just one approach. There are three elements to the resolution of this question: 1 - update the data ...
  • 4,973
1 vote
Accepted

Is it safe to use macros I created in Google's web apps?

If the macro is created by you then it is totally safe. The warning is general eg. it doesn't differentiate if the macro was created by you or by someone else. The whole procedure is just safety ...
  • 25.2k

Only top scored, non community-wiki answers of a minimum length are eligible