title: Google script string with variable
body: <p>I have a column of names that I am looping through and creating a new sheet from the value in each row.<br>
  I'm then trying to insert a string into cell A1 on each sheet. The string has a pointer in it to A1, A2, A3 etc<br>
  My code  creates a new sheet and on the new sheet inserts a string into A1. The first sheet is fine - points to A1 , the second points  to A11, the 3rd to A21 etc<br>
  Ideally I just want to put a variable in my cell range but can't see how to do that anywhere. If I just use I, then it starts at 0 so I'm out by one.
  Probably just being stupid but new to this. I can do it in VB but can't see what the problem is with this.</p>
  
  <pre><code>var sheetName = dataRange.getValues();
  
  for (i in sheetName) {
      var row = sheetName[i];
  
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      ss.insertSheet(row,i+1,{});
      var c1='=GOOGLEFINANCE(Parameters!$A$';
      var c2= i+1;
      var c3=', "all", Parameters!$B$2,Parameters!$B$4, "DAILY")';
      var c4 = c1.concat(c2);
      var c5 = c4.concat(c3);
  
      ss.getRange("A1").setValue(c5);
      SpreadsheetApp.setActiveSheet(ss.getSheets()[0]);
  }
  </code></pre>