Wilder1626
asked on
VB6 - Delete row if specific cell in Grid have a specific color
Hi.
I would like to know how i can delete all rows of my MSHFlexgrid1 that are not with a back color: &H80FF& in column 1.
How can i do that please?
Thanks
I would like to know how i can delete all rows of my MSHFlexgrid1 that are not with a back color: &H80FF& in column 1.
How can i do that please?
Thanks
Dim i As Long
For i = MSHFlexGrid1.Rows - 1 To 1 Step -1
If MSHFlexGrid1.TextMatrix(i, 1) .CellBackColor <> &H80FF& Then
MSHFlexGrid1.RemoveItem i
Else
End If
Next
What happens when you run that code? Does it compile?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is perfect.
Thanks again for your help.
Thanks again for your help.
You're welcome.