Thread: ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS?
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?
Reply With QuoteReply With Quote