Merged cells selection on a MSFlexGrid

[Neverbirth]

I'm a bit lost on this one... when several cells in a FlexGrid are merged both row/col and rowsel/colsel are always pointing to just one of the cells that are part of the merged one, so if you change one of its properties you don't change it for all the cells.

I'd like to know how you'd solve this, since the only methods I can think of right now are using two for loops, or modifying the database fields where these properties are set and reload the grid, and maybe the people with more experience know of some other better way.

[RhinoBull]

Somebody asked simmilar question:

http://www.vbforums.com/showthread.php?t=442733

[jcis]

When several cells in a FlexGrid are merged both row/col and rowsel/colsel are always pointing to just one of the cells that are part of the merged one, so if you change one of its properties you don't change it for all the cells.

You can do it changing FillStyle property value:

With MSFlexgrid1
     .Row = 1
     .Col = 1
     .RowSel = 5
     .ColSel = 3
 
     .FillStyle = flexFillRepeat
         'Make your multicell changes here, like..
         .CellBackColor = VbYellow
         .CellForecolor = VbBlue
     .FillStyle = flexFillSingle
End With

[Neverbirth]

Somebody asked simmilar question:

http://www.vbforums.com/showthread.php?t=442733

Thanks for the link, although I don't see any piece of code that gives hints about my problem.

You can do it changing FillStyle property value:

Well, that wouldn't fully solve my problem anyway, since it also requires knowing beforehand where the merged cell begins and where it ends.

Anyway, from reading both replies I guess another method (although not very accurate and could give some problems) would be to change the fillstyle value, select a great amount of cells around the selected one and change the back colour to the ones that have the same original properties, like text, colour, picture, etc. It would be a bit faster that doing two for loops...