Hello,
I am using C#NET 2008 and Version 2003 of Excel
At Row 1 trying to merge cell from Column 1 to Column 5 into a single cell to
insert the Customer Company name as Banner and my coding is not working due
to
my lack of knowledge.

--- Here the the coding. ---
private void FExportExcel()
{
using Microsoft.Office.Interop.Excel;

private Microsoft.Office.Interop.Excel.Application objExcel;
private Microsoft.Office.Interop.Excel.Workbook objWrkBook;
private Microsoft.Office.Interop.Excel.Worksheets objWrkSheet;
private Microsoft.Office.Interop.Excel.Range objWrkSheet_range;

int intRow = 1;
objExcel = new Microsoft.Office.Interop.Excel.Application();
objWrkBook = new objExcel.Workbooks;
objWrkSheet = new Worksheet();

//--- merge cells into one ---
objWrkSheet =(objWrkSheet.Cells[intRow, 1] ,
objWrkSheet.Cells[intRow,5]).MergeCells = true;

// --- insert Company name into merge cells ---
objWrkSheet.Cells[intRow, 1] = "Company Name : " +
this.txtCompanyName.Text;
}

Please help me. Once I got it working with you help, As an appreciate of your
help I will post the working coding here to share with other Newbies who may
have similar problem as

Thank You.
Regards.
Lennie