Range (“b3:b4”).ClearContents End Sub Now click the Run button and select Run Sub/UserForm. Close the VBA Editor and look at your spreadsheet; you will notice that the cell is cleared.

Select the module and go to the right tab. Next, paste the code you need. Finally close the window and go back to your workbook. You can find this code in your saved macros. To use this code, follow ...

ALT-F11 (opens the VBA coding window) Copy/Paste the above code into the editor ALT-F11 (switches back to Excel) Save-As a Macro-Enabled Workbook Use the functions like any other Excel Function ...

To examine the VBA code you recorded, click on Macros on the ribbon’s Developer tab, select your macro in the dialog box and click on Edit.