Range invalid

[Aidal]

Hello

I found a script on http://searchengineland.com/ to atomatically generate ETAs

The scripts displays in the log "The coordinates or dimensions of the range are invalid. (line 153)"

and the line is etaSheet.getRange(2, 6, numRows, 2).setFormulaR1C1("=LEN(R[0]-C[1])");

Also here is the entire section

var numRows = metaSheet.getDataRange().getNumRows() - 1;

  metaSheet.getRange(2, 6, numRows, 2).setFormulaR1C1("=LEN(R[0]-C[1])");

  metaSheet.getRange(2, 8, numRows, 1).setFormulaR1C1("=LEN(R[0]C[-1])");

  metaSheet.getRange(2, 10, numRows, 1).setFormulaR1C1("=LEN(R[0]C[-1])");    

  metaSheet.getRange(2, 12, numRows, 1).setFormulaR1C1("=LEN(R[0]C[-1])");  

  metaSheet.getRange(2, 14, numRows, 1).setFormulaR1C1("=LEN(R[0]C[-1])");  

  

  Logger.log("Finished... Results: " + spreadsheetUrl); 

I really dont understand whats wrontg with it and i hope you can help me

TIA 

  

[Vincent Racaza (AdWords Scripts Team)]

Hi AIdal,

Based on the error itself, it seems that there is something wrong on your spreadsheet on why it cannot get the ranges specified.

Also, since this is a third-party script, you may contact the author of the script so they can provide you support on this.

Furthermore, we also have an ETA Transition Helper solution script. You can try using this script to create expanded text ads from standard text ads if this is your main goal.

Thanks,

Vincent Racaza

AdWords Scripts Team