Clear columns VBA

[kishengiggs1]

I would like to clear my data in columns A,B,C in 7 of my worksheets in my workbook.

I need help creating a VBA for that?

Any help is appreciated.

 

[Smitty]

You can record a macro grouping the 7 sheets, then select columns A, B & C on the first sheet and delete.

That would be faster than looping through sheets too.

HTH,

 

[pgc01]

An example. For the worksheets "Sheet3", "Sheet5", "Sheet7", "Sheet8", try:

Sub DelCols()
 
Worksheets("Sheet3").Columns("A:C").Clear
 
Worksheets(Array("Sheet3", "Sheet5", "Sheet7", "Sheet8")).FillAcrossSheets Worksheets("Sheet3").Columns("A:C")
 
End Sub