Flexgrid , Change Merge and change Backcolor Cells

Hi

I need Merge some cells in flexgrid , after change backcolor from cells merged


tks

Example..

VB Code:

'Select mergefree, it could also be restricted ro rows or columns..
    MSFlexGrid1.MergeCells = flexMergeFree 'or.. flexMergeRestrictColumns or flexMergeRestrictRows
    
    'Merge cells in row 1..
    MSFlexGrid1.MergeRow(1) = True
    
    'Important! just cells with the same content (text) will be merged
    MSFlexGrid1.TextMatrix(1, 1) = "Hey!"
    MSFlexGrid1.TextMatrix(1, 2) = MSFlexGrid1.TextMatrix(1, 1)
    MSFlexGrid1.TextMatrix(1, 3) = MSFlexGrid1.TextMatrix(1, 1)

About the cell backcolor, change fillstyle to flexfillRepeat, make a selection using .row, .rowsel, .col, .colsel, then use MSFlexgrid.CellBackColor = SomeColor, and finally change fillstyle back to flexfillSingle