VBA .Cellbackcolor help please

[russell84]

Hi guys

 

i'm using a MSFlexgrid in a VBA and im using the following code to move date down rows when a button is clicked.

 

                   .Text = CInt(.Text) + 1
                   'add row and move drawing names down table
                   .Rows = .Rows + 1
                   For i = .Rows - 1 To .Row + CInt(.Text) Step -1
                       .TextMatrix(i, 0) = .TextMatrix(i - 1, 0)
                       .TextMatrix(i, 1) = .TextMatrix(i - 1, 1)
                       .TextMatrix(i, 2) = .TextMatrix(i - 1, 2)
                       .TextMatrix(i, 3) = .TextMatrix(i - 1, 3)

 

What i need to know is how to move not only the text down but how do i move the .CELLBACKCOLOR down aswell??

 

Thank you

[russell84]

Even just how do i do the following?

 

make the .CellBackColor of (cell row 2 - col 0 )= the .CellBackColor of cell row 1 - Col 0???

 

Thanks