I can't seem to find any solution. I know of the MergeCells() property, but that only seems to work in rows. I need to merge cells from A2:A10 for instance. Or is there a way to use the existing function for vertical merging as well?
I have learned that the correct syntax is worksheet.Cells[FromRow, FromColumn, ToRow, ToColumn].Merge = true; Thanks everyone