How to Get Last Row and Column Using Google Apps Script

In this video, I will show you how to get the next open row and column using Google Apps Script on Google Sheets.

Video, Code, and Documentation can be found at:

[blockwest]

awesome. nice, .... but how to find the "last" row in COL A if for example ColB has more entries? I struggle to append a row since I have formulas in COL D hidden. ;(

[sniperint]

I have 2 sheets (Order and Order Summary), In the Order Sheet, I have 4 columns (Food, Price, Qty, Total) and 5 rows. currently, Food and Price are auto-populated with data already all I have to do is to add the Qty and the total will come out, afterward will hit the Submit button to save the order in the Order Summary Sheet, the problem is when I populate the 2nd row and submit it, the only value I see in the order summary is only the first row. what should I do? pls help

[luiscorado]

Ok, thanks for sharing. I tried tthe code but for some reason It goes until row 1000, it doesn't detect the last row available. How can I fix it.

[jeffherz]

How would it be if you just need to pick up the last edited row and attach it to email and send?? I'm very new to this and i've been reading a lot and honestly I'm very confused. Thank you in advance

[boitraining]

Curt, How would I copy the last row (ignoring blanks) of a given sheet and paste it in a different sheet? I have been trying to copy the last row from my Form Responses sheet and paste it to another sheet. I can only get it to grab the ACTUAL last row from my Form Responses which is blank. I just need it to grab the last row with data. I'd appreciate any assistance. Thanks!

[aquastrummer]

hi.
how can i declare column A to E of the last row?