Merging Cells in Excel 2003

[Damian Arntzen]

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.

[Susan]

A trick I learned that works with most Microsoft products is to go to
Tools->Macros->Record->Record New Macro and then do whatever you are trying
to figure out what to do. When you view the macro, you then have the sytax. I
don't have .Net at home (so it's in VB, sorry), but try something like this:

Range("A1:B1"). Select
With Selection
.HorizontalAlig nment = xlGeneral
.VerticalAlignm ent = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = True
End With

I hope this helps.
Susan
"Damian Arntzen" wrote:

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.

[kids_pro]

Hi Damian A.

Try this out.

Excel.Applicati on xl = new Excel.Applicati onClass();

Excel.Workbook wb = xl.Workbooks.Ad d(Excel.XlWBATe mplate.xlWBATWo rksheet);

Excel.Worksheet ws = (Excel.Workshee t)wb.ActiveShee t;

ws.Cells[1,1] = "Testing";

Excel.Range range = ws.get_Range(ws .Cells[1,1],ws.Cells[1,2]);

range.Merge(tru e);

range.Interior. ColorIndex =36;

xl.Visible =true;

Cheers,

Kids

"Damian Arntzen" <Da***********@ discussions.mic rosoft.com> wrote in message
news:78******** *************** ***********@mic rosoft.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.

[Damian Arntzen]

Just tried it out - Works a wonder. I was close, but I guess thats the
trouble with teaching yourself - Tis a wee bit harder than normal. Thanks!

"kids_pro" wrote:

Hi Damian A.

Try this out.

Excel.Applicati on xl = new Excel.Applicati onClass();

Excel.Workbook wb = xl.Workbooks.Ad d(Excel.XlWBATe mplate.xlWBATWo rksheet);

Excel.Worksheet ws = (Excel.Workshee t)wb.ActiveShee t;

ws.Cells[1,1] = "Testing";

Excel.Range range = ws.get_Range(ws .Cells[1,1],ws.Cells[1,2]);

range.Merge(tru e);

range.Interior. ColorIndex =36;

xl.Visible =true;

Cheers,

Kids