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.