Hi Damian A.
Try this out.
Excel.Application xl = new Excel.ApplicationClass();
Excel.Workbook wb = xl.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorkshe et);
Excel.Worksheet ws = (Excel.Worksheet)wb.ActiveSheet;
ws.Cells[1,1] = "Testing";
Excel.Range range = ws.get_Range(ws.Cells[1,1],ws.Cells[1,2]);
range.Merge(true);
range.Interior.ColorIndex =36;
xl.Visible =true;
Cheers,
Kids
"Damian Arntzen" <Da***********@discussions.microsoft.com> wrote in message
news:78**********************************@microsof t.com...
I'm a beginner to moderate programmer who's fiddling around with
automating Excel, in particular after being able to have the user fill out a form and
it then generate the workbook. I can't quite figure out how to get it to
Merge cells together - I've found how to do it (I think) but can't nut out the
syntax. Any help with this would be much appreciated (I've tried looking
for online tutorials, but the ones I've found never touch merging).
Cheers,
Damian A.