Hi Peter,
I think you can merge the two example scripts I provided in my two replies. For example:
range rBook1ColA = [book1]sheet1!col(A); // column A in book1 sheet1
range rBook1fxColA = [book1]sheet1!col(fxColA); // column fxColA in book1 sheet1
range rBook1Wks = [book1]sheet1!; // sheet1 in book1
for(ii = 1; ii <= rBook1Wks.maxRows; ii++) // loop to get book names for calculation
{
string strBookname$ = rBook1ColA[ii]$; // get the book name
range rr = [strBookname$]sheet1!col(A); // define the corresponding column A
rBook1fxColA[ii] = max(rr); // calculate the maximum and put to column fxColA
}
Penn