Insert range in Excel

Hi guys I managed to get this far with my Excel spreadsheet: // Set the workbook to use and it's sheet $workbook=$_GLOBALS["templatedir"]."\ElectricityTransactions.XLT"; $sheet="Sheet1"; //Instantiate the spreadsheet component. $ex = new COM("Excel.sheet") or Die ("Did not connect"); //Open the workbook that we want to use. $wkb = $ex->application->Workbooks->Open($workbook) or Die ("Did not open"); //Create a copy of the workbook, so the original workbook will be preserved. $ex->Application->ActiveWorkbook->SaveAs($_GLOBALS["reportdir"]."\rpt_electrans_".trim($Outlet_session).".xls"); //$ex->Application->Visible = 1; #Uncomment to make Excel visible. //Read and write to a cells in the sheet $sheets = $wkb->Worksheets($sheet); //Select the sheet $sheets->activate; //Activate it $cell = $sheets->Cells(1,2) ; //Select the cell (Row Column number) $cell->activate; //Activate the cell $cell->value = "ELECTRICITY TRANSACTIONS Outlet ".trim($Outlet_session); //Change it But now how would I insert a range i.e., simulate in Excel the following: Select range B8:H8. Right click and select insert. Any ideas? Cheers Louis