Dave Peterson has brought this to us :
First, I don't speak C#.net.

But in VBA, I'd use something like:

objWrkSheet.Cells(intRow, 1).resize(1,5).mergecells = true

So maybe...

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

Even better! It's how I'd do it in VB/VBA, but not very informative to
a novice as to what's happening. I was hoping my reply provided some
educating content about how to manipulate the Range object (without
getting too carried away with it)!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc