delete alternate column
Hi Mary
This will delete every second column in your sheet. Take care
marcus
Sub RemCol()
Dim Col As Integer
Col = 2
Application.ScreenUpdating = False
For i = Col To 256 Step 2
Cells(1, Col).EntireColumn.Delete
Next i
End Sub
|