Help with Microsoft Flexgrid

[Muppet2009]

Hi

Just wondering if anyone can help me.

I've written a basic piece of code that searches through and excel sheet and brings it into a flexgrid.

If it finds the text that has been searched for it puts it into BOLD text. What I am trying to do is if it does not find anything then it removes it.

This is what I have got so far...

Dim rownum As Long
Dim rowtoremove As Long
Dim num As Long

If loggerflag = True Then
   Path = frmSoftRequest.cboLogger.Text
End If

frmSoftRequest.MSFlexGrid1.FillStyle = flexFillSingle

For i = 0 To frmSoftRequest.MSFlexGrid1.Cols - 1
    For j = 1 To frmSoftRequest.MSFlexGrid1.Rows - 1
        If InStr(frmSoftRequest.MSFlexGrid1.TextMatrix(j, i), Path) Then
            frmSoftRequest.MSFlexGrid1.col = i
            frmSoftRequest.MSFlexGrid1.row = j
            frmSoftRequest.MSFlexGrid1.CellFontBold = True
        ElseIf InStr(frmSoftRequest.MSFlexGrid1.TextMatrix(j, i), Path) = 0 And _
            frmSoftRequest.MSFlexGrid1.Rows <> 1 And frmSoftRequest.MSFlexGrid1.Cols <> 1 Then
            frmSoftRequest.MSFlexGrid1.RemoveItem (frmSoftRequest.MSFlexGrid1.row)
        End If
    Next j
Next i

[Hack]

If it finds the text that has been searched for it puts it into BOLD text. What I am trying to do is if it does not find anything then it removes it.

I'm scratchin' my head a little bit here.

If it doesn't find anything, it removes it....how can it remove something it didn't find?

[Muppet2009]

What it does it pulls everything into the flexgrid, then I want it to take out the rows that do not contain what i need.

[Hack]

In that case, why not just

ElseIf InStr(frmSoftRequest.MSFlexGrid1.TextMatrix(j, i), Path) = 0  Then
     frmSoftRequest.MSFlexGrid1.RemoveItem (frmSoftRequest.MSFlexGrid1.row)

[Muppet2009]

Have already tried that and comes up with "Cannot do a Removeitem on a Fixed Row.

As it is counting the headers as a row, and the headers are fixed.