Do you have a question? Post it now! No Registration Necessary. Now with pictures!
April 30, 2008, 4:48 am
rate this thread
sort as well.
I used this code and it's doesn't work and I do have Sheet1 in my
$CurrentSheet = $Workbook->Worksheets("Sheet1");
$RangeA = $CurrentSheet->Range("A1");
$RangeB = $CurrentSheet->Range("A20");
Key1 => $RangeA,
Order1 => xlDescending,
Key2 => $RangeB
I also want to freeze row 2 but this doesn't work as well.
$Excel->Rows("2")->Select; or $Excel->Rows("2:2")->Select;
$Excel->ActiveWindow-> = "True";
Any help? thanks a lot