A clear button that will clear certain cells on all sheets

[WebMistress]

Does anyone know the code for doing this? I know it's most likely going to be a VB code.

I have 7 worksheets and I need several cells in each worksheet that need to be cleared when a button is pressed on the first sheet.

Thanks.

 

[TryingToLearn]

Re: A clear button that will clear certain cells on all shee

see if this helps :

http://www.mrexcel.com/board2/viewtopic.php?t=76307

 

[WebMistress]

Re: A clear button that will clear certain cells on all shee

Thanks I will see if that fixs what I need for my spread sheets

 

[WebMistress]

What I did was... I went though the whole spread sheet and renamed the areas to rg1-10 then I made MasterClearList=rg-10 and created a button.

What is wrong with the following code? It's asking me to debug.


Private Sub CommandButton1_Click()
Range("MasterClearList").ClearContents
End Sub