But don't use semicolons.

Worksheets("Sheet2").Range("A1,A77,B6,D15,G5").Cle arContents
or maybe
Worksheets("Sheet2").Range("A1:A77,B6:D15,G5").Cle arContents



Michael M wrote:

Dorothy
If it is a Non Contigious range try
Worksheets("Sheet2").Range("A1;A77;B6;D15;G5").Cle arContents

etc,etc,

HTH
Michael M

"Castell" wrote:

Change the command to Worksheets("Sheet2").Range("A1:A77").ClearContents


"Dorothy" wrote in message
...
I am looking to set up a clear button on sheet 1 that when clicked on will
clear various cells on sheet two.

I have a clear button on sheet 1 that when clicked clears cells on sheet 1
that reads;
Range("A1:A77").ClearContents

but when I try to put that cammand button on page one to clear cells on
page
two I can't get the proper script that works.

any help is appreciated.

Dorothy


--

Dave Peterson