How do you select an adjacent cell from the active cell?

[burtran...@gmail.com]

Short on syntax...

[burtran...@gmail.com]

More specifically in my instance, the cell in an adjacent column...

On Thursday, June 17, 2021 at 9:59:23 AM UTC-7 burtran...@gmail.com wrote:

Short on syntax...

[burtran...@gmail.com]

Is it really just...

const adjacent = column + 1;   ???

[Marcos Gomes]

activeSheet.getRange(ActiveRow, ActiveColumn + 1)

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/33f3712c-2023-41dc-ba3a-31e1ee5b370dn%40googlegroups.com.

[Burt Paulie]

You're a champ...

Pipe long and aerogate,

Burt Paulie

925-204-9945

burtran...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANA%3DMHuduvUiiGf%3DPcMmyMMjiDcf8Ad-48hNdepXJgQXC%2BNetw%40mail.gmail.com.

[Burt Paulie]

Sorry to fuss, but I don't see ActiveRow or ActiveColumn in the GAS ref docs or online. Where do they come from again?

Pipe long and aerogate,

Burt Paulie

925-204-9945

burtran...@gmail.com

[Burt Paulie]

Sorry. I didn't mean to be so lazy about this, despite how trivial it is. Here's what I have. I'm trying to access an adjacent cell in a row and I've never done that before. Could you be more specific?

function getSheet() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getActiveSheet();
  const cell = sheet.getCurrentCell();
  const bool = cell.getBooleanCondition();
  const counter = cell.getRow()
}
 

Pipe long and aerogate,

Burt Paulie

925-204-9945

burtran...@gmail.com

[Marcos Gomes]

Try it
https://stackoverflow.com/questions/10691266/how-do-i-get-the-value-from-an-adjacent-cell-using-google-script-in-a-google-spr

Or use OnEdit() for use Triggers get cell position 

https://developers.google.com/apps-script/guides/triggers

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAM%3DS1TRgVT2JQ3%2Bg8RHoGH%2B13E8b3AB0PVXGDvFNHz2SDt538g%40mail.gmail.com.

[burtran...@gmail.com]

I can't. According to the docs ActiveRow and ActiveColumn are not valid syntax. 

[Marcos Gomes]

function onEdit(e) {

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getActiveSheet();

  const range = sheet.getActiveRange();

  const activeRow = range.getRow();
  const activeColumn = range.getColumn();

  //get adjacent cell in rigth column
  const adjCell = sheet.getRange(activeRow, activeColumn + 1).getA1Notation()

  console.log("activeRow: " + activeRow);
  console.log("activeColumn: " + activeColumn);
  console.log("Cell: " + adjCell);

  //view direct in browser
  Browser.msgBox("activeRow: " + activeRow + "\\n" + "activeColumn: " + activeColumn + "\\n" + "Cell: " + adjCell);
}

Another method:
  https://developers.google.com/apps-script/reference/spreadsheet/sheet#getactivecell  

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f00e5edd-92a4-4160-aadf-3bf3dbfb5bean%40googlegroups.com.

[Burt Paulie]

Like I said, You're a champ.

Pipe long and aerogate,

Burt Paulie

925-204-9945

burtran...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANA%3DMHtvNMacEX9EuY7ii-i%2BkhLiPZnS1%2B%2BQk0BQqA7z7mHG3w%40mail.gmail.com.

[Phillip Bainbridge]

Hi

As always in life - there is more than one way of doing this - you could use 'offset' as an alternative. I had a play around with this myself:

How to use 'offset' in a Google Sheet.

Kind regards

Phil