View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
traveye traveye is offline
external usenet poster
 
Posts: 9
Default ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS?

Thanks, it works great!

"Mike" wrote:

From the forms toolbox put a button on your sheet and when the popup window
comes up click on new macro and add the following code.

Range("B1:B12").Select
Selection.ClearContents

Mike

"traveye" wrote:

I want to add a button to a cell wich will clear data in a range of cells.
example: click on cell A1 and it will clear data from cell b1 thru b12. Is
this possible?