smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 164
- Office Version
- 2016
- Platform
- Windows
Hello.
I'm currently using the following code to clear cells in a Sheet2:
However, since I have about 30 Workbooks (all in the same folder) I would like to clear contents in all of them (range A1:Z50, Sheet2) with a one single macro run (without running 30 macros in each book separately).
Any idea how to solve this?
I'm currently using the following code to clear cells in a Sheet2:
Code:
Option Explicit
Sub Clear()
Worksheets("Sheet2").Range("A1:Z50").ClearContents
End Sub
However, since I have about 30 Workbooks (all in the same folder) I would like to clear contents in all of them (range A1:Z50, Sheet2) with a one single macro run (without running 30 macros in each book separately).
Any idea how to solve this?
Last edited: