//////////////////////////////////////////

newbook Book2;    //Create a new book to save the calculation result
col(1)[L]$ = "Min";    //Set column Longname
col(2)[L]$ = "Max";    //Set column Longname

win -a Book1;     //Active to Book1 with original datasets

// Following script is a loop script for 400 columns
for(ii=1; ii<=400; ii++)  
{
double aa;        //Declare a new variable of type double
aa=min(col($(ii)));      //get the minimum value from column(ii), and set value to “aa”
[book2]sheet1!Cell(ii,1)=aa;     //put “aa” value to Book2, sheet1, Column 1, row (ii)

double bb;      //Declare a new variable of type double
bb= max(col($(ii)));	    //get the maximum value from column(ii), and set value to “bb”
[book2]sheet1!Cell(ii,2)=bb;       //put “bb” value to Book2, sheet1, Column 2, row (ii)
}
win -a Book2;     //Active to Book2 

///////////////////////////////////////////////////////////