Columns Property Example

This example sets the font to bold in every other column in the visible range on the active worksheet.

For Each col In Spreadsheet1.ActiveSheet.VisibleRange.Columns
    If col.Column Mod 2 = 0 Then col.Font.Bold = True
Next

This example deletes all data from column 2 on the active worksheet.

Spreadsheet1.ActiveSheet.Columns(2).ClearContents