range r1 = col(B);
r1 = 0;
for (int i = 1; i<=10; i++)
{
	range rr = [A$(i)]1!2;
	r1 = r1 + rr;
}

quote:

---

Originally posted by YimingChen

Create a new worksheet, then run the LT script below in Window:Script Window:

range r1 = col(B);
r1 = 0;
for (int i = 1; i<=10; i++)
{
	range rr = [A$(i)]1!2;
	r1 = r1 + rr;
}

James

---

doc -e W  // Execute for all workbooks in the project
{
	range r1 = 2;
	range r2 = 3;
	newsheet name:=result cols:=1;
	col(A) = r1 + r2;
}