Clear contents

[Godders199]

Hello, expect a silly question, but does

VBA code Selection.clearcontents

Do the same as if you highlight all the sheet contents and press delete? I have just noticed that some of my code is not working correctly, however after using delete all is correct.

 

[vmjan02]

Yes it does
Code:-

Cells.Select
Selection.ClearContents

but so do so you have to select all the sheets in a workbook

Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Select

 

[Godders199]

hi thanks, I have changed to cells.clear which seems to work , just had to code in to reformat certain columns