Rick, assign this to a button
Sub Clear_Cells()
[B1:B5].ClearContents
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Rick" wrote in message
...
I am trying to make a button in a spreadsheet to clear a
certain area. Example: Click on button and it will clear
range B1-B5. What book would I need to get to tell me how
to do this.
Rick