[RESOLVED] Handling Excel application Using VB.Net

open your ms excel application. start recording a macro, then do whatever you want to the worksheet/workbook (ie merge cells, format cells, etc), and then turn it off when you're done. now, try to edit the macro, chadan! instant codes! :D

Mustaf, Thread1 merely suggested that you record a Macro in Excel, then whilst recording, do what you want, then stop recording. Now, after you've created the Macro, you can open the macro in Excel's VBA Editor by selecting:
Tools
Macro
Macros
Select the macro name in the list
Then, click on the Edit Button

This will open the VBA code behind the macro.
When I did it, it produced this :
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 18/08/2007 by HanneSThEGreaT
'
'
Range("A1:D2").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge
End Sub
Voila, there's how you merge cells.