Referring to all Excel worksheet cells using a macro
When you apply the Cells property to a spreadsheet in Microsoft Excel without specifying an index number, the method returns a Range object that represents all the Excel cells on the worksheet. The following Sub procedure clears the contents from all the cells on Excel Sheet1 in the active workbook.
Note: You cannot undo the actions of a macro.
Watch the video below to see the macro in action.