get range of cell equal value google sheet gscript code example

Example 1: cell get row google script

var cell = sheet1.getActiveCell();
var SelectRow = cell.getRow();

Example 2: google sheets get ranges

//getRange(row, column, optNumRows, optNumColumns);
Sheet.getRange(1,1,1,12);

//row --- int --- top row of the range
//column --- int--- leftmost column of the range
//optNumRows --- int --- number of rows in the range.
//optNumColumns --- int --- number of columns in the range