Google script string with variable
<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>