hi,
In flex , i want to merge the particular column data for 1st and 2nd row. but i don't want to merge the same column data for the remaining
rows. i've given an example, where the 4th column data of 1st two rows can be merged as "Address" where its data "INDIA" should not be merged for the remaining two rows.
is it possible in flex.
can anyone help me in this, if it is possible.

with flex
   .FixedRows = 0
   .FixedCols = 0

   .MergeCells = flexMergeRestrictColumns

   .MergeRow(0) = True
   .MergeCol(0) = True
   .MergeCol(4) = True ' i want the heading of this column alone to be merged not the data "INDIA"

   .TextMatrix(0, 0) = "Sl. No."
   .TextMatrix(0, 1) = "Employee Details"
   .TextMatrix(0, 2) = "Employee Details"
   .TextMatrix(0, 3) = "Employee Details"
   .TextMatrix(0, 4) = "Address"

   .TextMatrix(1, 0) = "Sl. No."
   .TextMatrix(1, 1) = "NAME"
   .TextMatrix(1, 2) = "Age"
   .TextMatrix(1, 3) = "Gender"
   .TextMatrix(1, 4) = "Address"

   .TextMatrix(2, 0) = "1"
   .TextMatrix(2, 1) = "priya"
   .TextMatrix(2, 2) = "20"
   .TextMatrix(2, 3) = "F"
   .TextMatrix(2, 4) = "INDIA"

   .TextMatrix(3, 0) = "2"
   .TextMatrix(3, 1) = "priya"
   .TextMatrix(3, 2) = "20"
   .TextMatrix(3, 3) = "F"
   .TextMatrix(3, 4) = "INDIA"

thank u
R.S.Shanmuga Priya.

use flexMergeRestrictAll instead of flexMergeRestrictColumns

Regards,
Marco

Thanks macro, even then the 4th column's heading and data are not merged.
i want the heading "Address" to be merged wherein
i don't want the data "INDIA" to be merged.

Thanku