for (int i = 2; i <= page.nlayers;i++) {
	page.active = i;
	wks.col = 2;
	wks.insert();
	range rs = 1!;
	wks.col.formula$ = %(rs.col2.formula$);
	wks.col.lname$ = %(rs.col2.lname$);
}

quote:

---

Originally posted by YimingChen

You may try the script below:

for (int i = 2; i <= page.nlayers;i++) {
	page.active = i;
	wks.col = 2;
	wks.insert();
	range rs = 1!;
	wks.col.formula$ = %(rs.col2.formula$);
	wks.col.lname$ = %(rs.col2.lname$);
}

Yiming

---

quote:

---

Originally posted by cpyang

We are adding this ability in 2026b to add column to other sheets.
We can work on also Insert support.
Or adding is good enough?




CP

---