I would like to know how can I get the end row of my sheet (not the last row with data). Is there a simple code to get that?
You can use getMaxRows() to get the end row number.
getMaxRows()
Sample:
Reference: