Better Sheets

class SpreadsheetApp method .getActive()

SpreadsheetApp is the Apps Script service.

.getActive() is the method name you will see after a dot in your code.

What it does

Returns the range the user currently has selected.

Why it's used

Common errors

Forgetting parentheses on getActive. Write SpreadsheetApp.getActive(), not SpreadsheetApp.getActive or getActive by itself.
Skipping dots between chained calls. Each step needs a dot, like SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data').getActive().
Adding spaces where they do not belong. Write SpreadsheetApp.getActive(), not SpreadsheetApp .getActive(), SpreadsheetApp.getActive (), or SpreadsheetApp . getActive().
Wrong capitalization. Use SpreadsheetApp and getActive, not spreadsheetapp or getactive.

2 Snippets using this methods

Official Google docs

Explore

2 Better Sheets tutorials

Add a Custom Menu Create Native-like Functions Get URL and Sheet ID's vi...

Advanced Intermediate

Created a tournament template with 4 automations. So tabs can be copied ...

Intermediate

SORT() SUM() SUMIF() UNIQUE()