How to specify the range of all rows containing data in Google Sheets

Question

What is the syntax for selecting the full range of rows which contain data?

Say for instance I have 200 rows of data. Im running some functions which loop through rows. If I wanted to select the range of these rows manually from column A, I would write is as A1:A200.
But is there a way to write it from "A1" : "last row in the column A that contains an entry"

Alternatively is there a way to write A1:"end of column A, regardless of entries"?

thanks

Wellerman · Accepted Answer · 2021-04-15 13:19:26Z

1

You can write A1:A to get the entire column, or A1:Z to get a range of columns. In Apps Script, you can call sheet.getLastRow() (or sheet.getLastColumn()) to get the last row containing data and use that to write your loops.

References

edited Apr 15, 2021 at 13:19

answered Apr 14, 2021 at 12:37

Wellerman

8566 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JPV · Accepted Answer · 2021-04-14 14:00:03Z

0

You can also consider the use of getDataRange().This method returns a Range corresponding to the dimensions in which data is present.

answered Apr 14, 2021 at 14:00

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to specify the range of all rows containing data in Google Sheets

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related