private Excel.Range addFirstCol(ref Excel.Range pRng, Excel.Range vCurCol) { int vCurColN = vCurCol.Column; int vCurRowN = vCurCol.Row; int vCurRowsN = vCurCol.Rows.Count; vCurCol.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, true); Excel.Range vNewCol = ExcelSrv.getRange(vCurCol.Worksheet, vCurCol.Worksheet.Cells[vCurRowN, vCurColN], vCurCol.Worksheet.Cells[vCurRowN + vCurRowsN, vCurColN]); vCurCol.Copy(vNewCol); vCurCol.ColumnWidth = vNewCol.ColumnWidth; return vCurCol; }