range r1 = [book1]1!1;
win -a %(r1.GetPage()$); // activate the page
range rwks = r1.GetLayer()$;
page.active$ = rwks.name$; // activate the sheet
wks.colSel(Colnum(r1), 1); // select the column

String strRange = %(r1);

quote:

---

Originally posted by YimingChen

If you have one column in the range, you can try the sample script below:

range r1 = [book1]1!1;
win -a %(r1.GetPage()$); // activate the page
range rwks = r1.GetLayer()$;
page.active$ = rwks.name$; // activate the sheet
wks.colSel(Colnum(r1), 1); // select the column

If you have multiple columns, you may need to parse the range string to get the columns. The range string can be obtained by:

String strRange = %(r1);

James

---

range rd = [Book2]Sheet3!5:10;
String strRange = %(rd);
int colStart = value(between(strRange$,"!",":")$);
int colEnd = value(GetToken(strRange$,2,":")$);
colStart=;
colEnd=;

quote:

---

Originally posted by YimingChen

For example, if you have multiple columns in a range. You need to get the start and end columns, you may use:

range rd = [Book2]Sheet3!5:10;
String strRange = %(rd);
int colStart = value(between(strRange$,"!",":")$);
int colEnd = value(GetToken(strRange$,2,":")$);
colStart=;
colEnd=;

James

---

quote:

---

Originally posted by YimingChen

Pass the column index from colStart to colEnd into the wks.colSel() function.

---