select multiple cells in MSHFlexGrid

[bushmobile]

well i haven't tried to work out what you're trying to do, but here's how you change the backcolor of a groups of cells (without looping):

With MSFlexGrid1
    .Redraw = False
    .FillStyle = flexFillRepeat
 
    ' top left of the section you want to change
    .Col = 1
    .Row = 3
 
    ' bottom right of the section
    .ColSel = 3
    .RowSel = 5
 
    ' Set any cell properties
    .CellBackColor = vbBlue
    
    .FillStyle = flexFillSingle
    .Redraw = True
End With

you might be interested in looking at the MSFlexGrid selection link in my signature for an example of this in practice.