Google Product Forums

Trouble with ImportRange

Gaura Apr 25, 2012 5:39 AM
Posted in group: Google Docs

Categories: Sheets : Share an idea : Mobile device (specify device type/OS) :

Hi i tried to use this Script for Importrange from my Target workbook.
but i could not found that where i did mistake for this advise Page Ref:

My Setup as below;

function ImportDataRange() {

 var ss = SpreadsheetApp.getActiveSpreadsheet();

 var sheet = ss.getSheetByName("Sheet1");

 var ssraw = SpreadsheetApp.openById("0AhioeCK_-aU4dHlLWjlDd0J5LVNyNHVVSEdQQnFsNEE");

 var sheetraw = ssraw.getSheetByName("Sheet1");

 var range = sheetraw.getRange("A2");

 var data = range.getValues();
  
 sheet.getRange("AZ2000").setValues(data)

 }

and the Result as error: You do not have permission to call setValues (line 15)

some please advise on it.

Thanks!