Get cell’s value

Here is how to get cell’s value

 

 

Source code

function getValue(){
  var val = "Confident is very important";
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getActiveSheet();

  var vl = sh.getRange("$A$1").getValue();

  Browser.msgBox("A1=" + vl);
}

 

 

Format

RangeObject.getValue()

 

Returns

value

 

How to get range object?

Get active range or active cell object

Get range or cell object by row and column number

Get range or cell object by address

Leave a Comment