> I need to clear the grid between updates without clearing
the header row. What is the speediest way to do this?
What about a subroutine along these lines?
Sub ClearAllExceptHeaderRow()
Dim CurrentRow As Long
Dim CurrentCol As Long
Dim CurrentRepeatStyle As Long
With MSFlexGrid1
CurrentRow = .Row
CurrentCol = .Col
CurrentRepeatStyle = .FillStyle
.FillStyle = flexFillRepeat
.Row = 1
.Col = 0
.RowSel = .Rows - 1
.ColSel = .Cols - 1
.Text = ""
.Row = CurrentRow
.Col = CurrentCol
.FillStyle = CurrentRepeatStyle
.SetFocus
End With
End Sub
Rick - MVP