method Columns.Remove (Index as Variant)
Removes a specific member from the Columns collection.

TypeDescription
Index as Variant A long expression that indicates the column's index being removed, or a string expression that indicates the column's caption or column's key

The Remove method removes a specific column in the Columns collection. Use Clear method to remove all Column objects. The RemoveColumn event is fired when a column is about to be removed. Use the Visible property to hide a column.