removing/hiding columns in msflexgrid

[lie08]

Hi to everyone.

I want to know how to remove/hide columns in msflexgrid. I'm going to do this for printing the control but not all the columns are included. Can someone help me with this? Thank you in advance.

[sunco]

Have you try this ? this "hide" the columns but still there (just not visible)

Flex1.ColWidth(3) = 0

3 is the Number of the Column

[lie08]

No, I haven't. Thank you for this.

[brucevde]

The FlexGrid does not have an internal method to delete a column but its easy to do using this simple procedure.

Public Sub DeleteColumn(FlexGrid As MSFlexGrid, ByVal Column As Long)
    With FlexGrid
        'move the column to delete to the end
        .ColPosition(Column) = .Cols - 1
        .Cols = .Cols - 1 'change the number of columns
    End With
End Sub

[lie08]

brucevde,

Thank you for your help. I'm now ok with this. :-)