VBA to delete columns A through to D on a specific Worksheet

[mistrellis]

Pretty much what the title says:

Need a command button on a worksheet that runs code to delete all data in Columns A through D (incl) on "Sheet4" as a way to cleanse the workfile for additional data import.

Note that there are formulas on "Sheet4" in columns E through U that reference the data that is to be deleted and subsequently re-imported.

Would it just be easier to manually record the macro and assign it to the command button ?

Regards

 

[CamFlawless]

Try something such as the following:

Sub Del_Cols ()

Sheets("Sheet4").Range("A:D").EntireColumn.ClearContents 


End Sub