Google Sheets packs a lot of powerful features under its simple interface. Try these intermediate tips to take your ...

An Excel spreadsheet containing a spilled calculation that automatically picks up new rows due to the addition of the TRIMRANGE function.

As far as your code is concerned, it's the same as if you were adding a new row to an Access table; the Jet OLEDB provider handles the details in the background.