0

If there is a column of 10 full cells in a row, and you go to the top of the column and hit command + down arrow, it activates the lowest non-empty cell.

I tried to record a macro while using cmd + down arrow, but instead of activating the lowest non-empty cell, it just activates the same cell over and over. I tried .getLastRow().

How do I move to the lowest non-empty cell in a column, or how do I replicate the cmd + ↓ behavior?

2
  • Hi and welcome to WebApps. You said you tried .getLastRow(). Would you please show the code that you tried. .getLastRow() has a context for a range and a different context for a sheet. So whether and why it didn't work would depend on how your wrote your code. Also, .getLastRow() doesn't move the cursor, it just creates a target; you have to set an active range that is defined by .getLastRow()
    – Tedinoz
    Dec 31 '21 at 2:21
  • 1
    Does this answer your question? Quickly scroll to the last row with data in Google Sheets on a Mac
    – Tedinoz
    Dec 31 '21 at 2:21
1

Use getNextDataCell(), like this:

  const spreadsheet = SpreadsheetApp.getActive();  
  spreadsheet.getCurrentCell()
    .getNextDataCell(SpreadsheetApp.Direction.DOWN)
    .offset(1, 0)
    .activate();
3
  • I see. That works. Thank you :) But that takes me to the bottom most cell with characters in it. How do I go one cell down from that?
    – aishlia
    Jan 3 at 4:39
  • Sorry, I figured it out. I'm very new to this (obviously). I just did: spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate(); spreadsheet.getCurrentCell().offset(1,0).activate();
    – aishlia
    Jan 3 at 4:50
  • I gather that this is your first question at Stack Exchange. See What should I do when someone answers my question? Jan 4 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.