Clear cell multiple worksheets

[k9lover]

I have a workbook with about 50 sheets. I need to clear the value from cell B15 in every sheet in that workbook. Thank you in advance!

 

[CWatts]

The easiest way is to click on the first work sheet in the bottom left. Then click the >| button to move to the last sheet. Hold down the shift key and click the last sheet which selects all workbooks.

Click on B15 and push delete.

Since all sheets were highlighted, all sheets B15 will be cleared.

Can also be done with a macro if needed.

Sub ClearB15()
    Dim ws As Worksheet
    For Each ws In ActiveWorkbook.Worksheets
        ws.Range("B15").ClearContents
    Next ws
End Sub

 

[k9lover]

And if I wanted to use a macro, how would I do that?

 

[CWatts]

ALT+F11
Insert Menu
Choose "Module"
Copy and paste that CODE section.

Depending on the version of excel you'll access your macros and run it.

In 2003 and earlier I believe they're in the tools menu. in 2007 you need to go into the excel options and show developer tab on ribbon to access macros.

From there you can insert a button (Form control) and assign the macro to it so whenever you push that button it runs, or you can assign a keyboard shortcut.

 

[k9lover]

Great! Thank you so much!