If you don't need to specify a specific range of cells each time, just record a macro of you clearing what you need to clear, name it, then insert a button into your sheet that executes the macro. Otherwise, you will need either a userform, or have Excel pull your clear range from the sheet itself and assign the range values to variables in your macro.