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