Looking for assistance to make simple VBA modification

[bepedicino]

I need the VBA to delete Column "F" as the very last step in the process. Since I am not familiar with VBA I am looking for help. It would be greatly appreciated if you could assist.

Sub valuesAndDelete()

With Application
.Calculate
.ScreenUpdating = False
.Calculation = xlCalculationManual
.DisplayAlerts = False
End With

With ActiveSheet
.Columns.Hidden = False
.Rows.Hidden = False
.UsedRange.Value = .UsedRange.Value
End With

For Each Worksheet In ThisWorkbook.Worksheets
If Worksheet.Name = ActiveSheet.Name Then
Else
Worksheet.Delete
End If
Next Worksheet

With Application
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
.DisplayAlerts = True
End With


End Sub

 

[alansidman]

Range("F1").entirecolumn.delete

 

[Rick Rothstein]

Range("F1").entirecolumn.delete

This will also work...

Columns("F").Delete

 

[bepedicino]

Thank you Rick, I appreciate the assistance.