create spreadsheet named with each value in a range code example

Example: spreadsheet range to a variable

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
var range = sheet.getRange('A1:D10');
//range.activate();
var values = range.getValues();
//Logger.log(values[0][0]);