What is the Range object in Google Sheets?
Excel's Range object represents cells you read or write in VBA. Apps Script uses Range too, returned by spreadsheet.getRange(), getActiveRange(), or getRangeByName(). Methods like getValue, setValues, and getValues map closely to common VBA Range calls.
When to use it
Use getRange patterns when porting VBA that loops through cells or resizes destinations.
When to skip it
Skip row-by-row loops when one array formula or setValues on a 2D array is faster.
Better Sheets resources
Related Tutorials
Watch how Range object works
Google Sheets Error: Unknown Range Name and How to Fix it
Related glossary terms
getRange
getRange returns a Range object pointing at one or more cells on a sheet. You call it on a Sheet to read with getValue or getValues and write with setValue or setValues. Correct range targeting is the foundation of almost every Sheets script.
Read guide →getValue
getValue reads the value from one cell in a Range object. It returns what you see in the grid as a string, number, date, or boolean. Scripts use getValue when they need one field at a time, such as a status flag, email address, or threshold from a Settings tab.
Read guide →getValues
getValues reads every cell in a range into a two-dimensional JavaScript array. The outer array is rows and the inner arrays are columns. It is the standard way to pull a table from a sheet, loop through it, filter rows, and write results elsewhere in one efficient pass.
Read guide →Google Apps Script
Apps Script is Google's JavaScript platform for automating Sheets and other Workspace apps. From a spreadsheet you can open Extensions > Apps Script to write code that reads cells, sends email, builds menus, and runs on triggers. It goes beyond formulas when you need custom workflows tied to your file.
Read guide →Done reading about Range object?
Membership unlocks 637+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.